eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FRR_DATA_PUMP dependencies on PAY_STATUS_PROCESSING_RULES

Line 96: l_element_type_id pay_status_processing_rules.element_type_id%type;

92: ,p_language_code in varchar2
93: )
94: return number is
95: --
96: l_element_type_id pay_status_processing_rules.element_type_id%type;
97: l_ass_status_typ_id pay_status_processing_rules.assignment_status_type_id%type;
98: l_spr_id pay_status_processing_rules.status_processing_rule_id%type;
99: --
100: Begin

Line 97: l_ass_status_typ_id pay_status_processing_rules.assignment_status_type_id%type;

93: )
94: return number is
95: --
96: l_element_type_id pay_status_processing_rules.element_type_id%type;
97: l_ass_status_typ_id pay_status_processing_rules.assignment_status_type_id%type;
98: l_spr_id pay_status_processing_rules.status_processing_rule_id%type;
99: --
100: Begin
101:

Line 98: l_spr_id pay_status_processing_rules.status_processing_rule_id%type;

94: return number is
95: --
96: l_element_type_id pay_status_processing_rules.element_type_id%type;
97: l_ass_status_typ_id pay_status_processing_rules.assignment_status_type_id%type;
98: l_spr_id pay_status_processing_rules.status_processing_rule_id%type;
99: --
100: Begin
101:
102: l_element_type_id := get_source_element_type_id

Line 115: from pay_status_processing_rules_f spr

111: );
112: Begin
113: select status_processing_rule_id
114: into l_spr_id
115: from pay_status_processing_rules_f spr
116: where spr.element_type_id = l_element_type_id
117: and p_effective_date between spr.effective_start_date
118: and spr.effective_end_date
119: and (spr.business_group_id + 0 = p_business_group_id