APPS.HR_USER_INIT_DEDN dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 3477: FROM pay_status_processing_rules_f

3473:
3474: hr_utility.set_location('hr_user_init_dedn.ins_uie_inp_values',85);
3475: SELECT status_processing_rule_id
3476: INTO v_status_proc_id
3477: FROM pay_status_processing_rules_f
3478: WHERE assignment_status_type_id IS NULL
3479: AND element_type_id = p_ele_type_id;
3480:
3481: --

Line 4926: FROM pay_status_processing_rules_f spr, ff_formulas_f ff

4922: AND business_group_id = p_business_group_id;
4923:
4924: CURSOR get_formulae(l_ele_id in number) IS
4925: SELECT distinct ff.formula_id
4926: FROM pay_status_processing_rules_f spr, ff_formulas_f ff
4927: WHERE spr.element_type_id = l_ele_id
4928: AND ff.formula_id = spr.formula_id
4929: AND ff.business_group_id = p_business_group_id;
4930:

Line 4943: FROM pay_status_processing_rules_f

4939: AND ff.business_group_id = p_business_group_id;
4940:
4941: CURSOR get_spr(l_ele_id in number) IS
4942: SELECT distinct status_processing_rule_id
4943: FROM pay_status_processing_rules_f
4944: WHERE element_type_id = l_ele_id
4945: AND business_group_id = p_business_group_id;
4946:
4947: --