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 1092: FROM pay_status_processing_rules_f

1088: p_bg_id IN NUMBER,
1089: p_assgn_status_id IN NUMBER
1090: ) IS
1091: SELECT status_processing_rule_id
1092: FROM pay_status_processing_rules_f
1093: WHERE element_type_id = p_element_type_id
1094: AND business_group_id = p_bg_id;
1095:
1096: CURSOR c_formula_id (

Line 1111: FROM pay_status_processing_rules_f PSP,

1107: l_processing_rule VARCHAR2,
1108: l_business_group_id NUMBER
1109: ) IS
1110: SELECT FF.formula_name
1111: FROM pay_status_processing_rules_f PSP,
1112: ff_formulas_f FF
1113: WHERE PSP.element_type_id = l_element_type_id
1114: AND PSP.processing_rule = l_processing_rule
1115: AND FF.formula_id = PSP.formula_id

Line 1730: FROM pay_status_processing_rules_f

1726: ) IS
1727: SELECT status_processing_rule_id
1728: , effective_start_date
1729: , object_version_number
1730: FROM pay_status_processing_rules_f
1731: WHERE element_type_id = p_element_type_id
1732: AND ((business_group_id = p_business_group_id AND
1733: legislation_code IS NULL) OR
1734: (business_group_id IS NULL AND

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

1819: ,p_effective_start_date => l_eff_start_date
1820: ,p_effective_end_date => l_eff_end_date
1821: );
1822: ELSE
1823: hr_utility.TRACE ('pay_status_processing_rules_f does not return any row');
1824: END IF;/*c_stat_proc_rule%FOUND*/
1825: CLOSE c_stat_proc_rule;
1826:
1827: END IF;/*l_shadow_ele_type_id IS NOT NULL*/