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 771: from pay_status_processing_rules_f spr

767: --
768: Cursor c_spr_element
769: is
770: select spr.element_type_id
771: from pay_status_processing_rules_f spr
772: where spr.status_processing_rule_id = p_status_processing_rule_id
773: and p_effective_date between spr.effective_start_date
774: and spr.effective_end_date;
775: --

Line 965: ,pay_status_processing_rules_f spr

961: --
962: Cursor c_result_dtype is
963: select fdu.data_type
964: from ff_fdi_usages_f fdu
965: ,pay_status_processing_rules_f spr
966: where spr.status_processing_rule_id = p_status_processing_rule_id
967: and fdu.formula_id = spr.formula_id
968: and fdu.usage in ('O', 'B')
969: and fdu.item_name = p_result_name

Line 1203: l_spr_formula_id pay_status_processing_rules_f.formula_id%type;

1199: l_future_rule_end_date date;
1200: l_max_spr_end_date date;
1201: l_max_end_date_of_element date;
1202: l_max_end_date_of_target date;
1203: l_spr_formula_id pay_status_processing_rules_f.formula_id%type;
1204: l_spr_element_type_id pay_status_processing_rules_f.element_type_id%type;
1205: --
1206: Cursor c_spr_element
1207: is

Line 1204: l_spr_element_type_id pay_status_processing_rules_f.element_type_id%type;

1200: l_max_spr_end_date date;
1201: l_max_end_date_of_element date;
1202: l_max_end_date_of_target date;
1203: l_spr_formula_id pay_status_processing_rules_f.formula_id%type;
1204: l_spr_element_type_id pay_status_processing_rules_f.element_type_id%type;
1205: --
1206: Cursor c_spr_element
1207: is
1208: select spr.formula_id,spr.element_type_id

Line 1209: from pay_status_processing_rules_f spr

1205: --
1206: Cursor c_spr_element
1207: is
1208: select spr.formula_id,spr.element_type_id
1209: from pay_status_processing_rules_f spr
1210: where spr.status_processing_rule_id = p_status_processing_rule_id
1211: and p_effective_date between spr.effective_start_date
1212: and spr.effective_end_date;
1213: --