APPS.HR_USER_INIT_DEDN dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 3575: FROM pay_status_processing_rules_f

3571:
3572: hr_utility.set_location('hr_user_init_dedn.ins_uie_inp_values',85);
3573: SELECT status_processing_rule_id
3574: INTO v_status_proc_id
3575: FROM pay_status_processing_rules_f
3576: WHERE assignment_status_type_id IS NULL
3577: AND element_type_id = p_ele_type_id;
3578:
3579: --

Line 5052: FROM pay_status_processing_rules_f spr, ff_formulas_f ff

5048: AND business_group_id = p_business_group_id;
5049:
5050: CURSOR get_formulae(l_ele_id in number) IS
5051: SELECT distinct ff.formula_id
5052: FROM pay_status_processing_rules_f spr, ff_formulas_f ff
5053: WHERE spr.element_type_id = l_ele_id
5054: AND ff.formula_id = spr.formula_id
5055: AND ff.business_group_id = p_business_group_id;
5056:

Line 5069: FROM pay_status_processing_rules_f

5065: AND ff.business_group_id = p_business_group_id;
5066:
5067: CURSOR get_spr(l_ele_id in number) IS
5068: SELECT distinct status_processing_rule_id
5069: FROM pay_status_processing_rules_f
5070: WHERE element_type_id = l_ele_id
5071: AND business_group_id = p_business_group_id;
5072:
5073: --