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_BUS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 562: from pay_status_processing_rules_f spr

558:
559: Cursor c_chk_spr
560: is
561: select null
562: from pay_status_processing_rules_f spr
563: where spr.status_processing_rule_id = p_status_processing_rule_id
564: and p_effective_date between spr.effective_start_date
565: and spr.effective_end_date
566: and ((p_business_group_id is not null and

Line 616: ,pay_status_processing_rules_f spr

612: Cursor c_chk_result_name
613: is
614: select null
615: from ff_fdi_usages_f fdu
616: ,pay_status_processing_rules_f spr
617: where spr.status_processing_rule_id = p_status_processing_rule_id
618: and fdu.formula_id = spr.formula_id
619: and fdu.usage in ('O', 'B')
620: and fdu.item_name = p_result_name

Line 763: from pay_status_processing_rules_f spr

759: --
760: Cursor c_spr_element
761: is
762: select spr.element_type_id
763: from pay_status_processing_rules_f spr
764: where spr.status_processing_rule_id = p_status_processing_rule_id
765: and p_effective_date between spr.effective_start_date
766: and spr.effective_end_date;
767: --

Line 946: ,pay_status_processing_rules_f spr

942: --
943: Cursor c_result_dtype is
944: select fdu.data_type
945: from ff_fdi_usages_f fdu
946: ,pay_status_processing_rules_f spr
947: where spr.status_processing_rule_id = p_status_processing_rule_id
948: and fdu.formula_id = spr.formula_id
949: and fdu.usage in ('O', 'B')
950: and fdu.item_name = p_result_name

Line 1184: l_spr_formula_id pay_status_processing_rules_f.formula_id%type;

1180: l_future_rule_end_date date;
1181: l_max_spr_end_date date;
1182: l_max_end_date_of_element date;
1183: l_max_end_date_of_target date;
1184: l_spr_formula_id pay_status_processing_rules_f.formula_id%type;
1185: l_spr_element_type_id pay_status_processing_rules_f.element_type_id%type;
1186: --
1187: Cursor c_spr_element
1188: is

Line 1185: l_spr_element_type_id pay_status_processing_rules_f.element_type_id%type;

1181: l_max_spr_end_date date;
1182: l_max_end_date_of_element date;
1183: l_max_end_date_of_target date;
1184: l_spr_formula_id pay_status_processing_rules_f.formula_id%type;
1185: l_spr_element_type_id pay_status_processing_rules_f.element_type_id%type;
1186: --
1187: Cursor c_spr_element
1188: is
1189: select spr.formula_id,spr.element_type_id

Line 1190: from pay_status_processing_rules_f spr

1186: --
1187: Cursor c_spr_element
1188: is
1189: select spr.formula_id,spr.element_type_id
1190: from pay_status_processing_rules_f spr
1191: where spr.status_processing_rule_id = p_status_processing_rule_id
1192: and p_effective_date between spr.effective_start_date
1193: and spr.effective_end_date;
1194: --