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

Line 1037: FROM pay_status_processing_rules_f

1033: p_bg_id IN NUMBER,
1034: p_assgn_status_id IN NUMBER
1035: ) IS
1036: SELECT status_processing_rule_id
1037: FROM pay_status_processing_rules_f
1038: WHERE element_type_id = p_element_type_id
1039: AND business_group_id = p_bg_id;
1040:
1041: CURSOR c_formula_id (

Line 1056: FROM pay_status_processing_rules_f PSP,

1052: l_processing_rule VARCHAR2,
1053: l_business_group_id NUMBER
1054: ) IS
1055: SELECT FF.formula_name
1056: FROM pay_status_processing_rules_f PSP,
1057: ff_formulas_f FF
1058: WHERE PSP.element_type_id = l_element_type_id
1059: AND PSP.processing_rule = l_processing_rule
1060: AND FF.formula_id = PSP.formula_id

Line 1675: FROM pay_status_processing_rules_f

1671: ) IS
1672: SELECT status_processing_rule_id
1673: , effective_start_date
1674: , object_version_number
1675: FROM pay_status_processing_rules_f
1676: WHERE element_type_id = p_element_type_id
1677: AND ((business_group_id = p_business_group_id AND
1678: legislation_code IS NULL) OR
1679: (business_group_id IS NULL AND

Line 1768: hr_utility.TRACE ('pay_status_processing_rules_f does not return any row');

1764: ,p_effective_start_date => l_eff_start_date
1765: ,p_effective_end_date => l_eff_end_date
1766: );
1767: ELSE
1768: hr_utility.TRACE ('pay_status_processing_rules_f does not return any row');
1769: END IF;/*c_stat_proc_rule%FOUND*/
1770: CLOSE c_stat_proc_rule;
1771:
1772: END IF;/*l_shadow_ele_type_id IS NOT NULL*/