APPS.PAY_MX_FF_UDFS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 966: c_get_last_idw_action(cp_asg_id pay_assignment_actions.assignment_id%TYPE,

962: AND p_effective_date BETWEEN b.effective_start_date
963: AND b.effective_end_date;
964:
965: CURSOR
966: c_get_last_idw_action(cp_asg_id pay_assignment_actions.assignment_id%TYPE,
967: cp_idw_report_date DATE,
968: cp_idw_start_date DATE) IS
969: SELECT assignment_action_id
970: FROM pay_assignment_actions aa,

Line 970: FROM pay_assignment_actions aa,

966: c_get_last_idw_action(cp_asg_id pay_assignment_actions.assignment_id%TYPE,
967: cp_idw_report_date DATE,
968: cp_idw_start_date DATE) IS
969: SELECT assignment_action_id
970: FROM pay_assignment_actions aa,
971: pay_payroll_actions pa
972: WHERE assignment_id = cp_asg_id
973: AND tax_unit_id = p_tax_unit_id
974: AND aa.source_action_id IS NOT NULL

Line 1034: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;

1030:
1031: rn_idw NUMBER;
1032: ln_rate NUMBER;
1033: ln_variable_idw NUMBER;
1034: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;
1035: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;
1036: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1037: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1038: lb_gre_ambiguous BOOLEAN;

Line 1035: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;

1031: rn_idw NUMBER;
1032: ln_rate NUMBER;
1033: ln_variable_idw NUMBER;
1034: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;
1035: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;
1036: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1037: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1038: lb_gre_ambiguous BOOLEAN;
1039: lb_gre_missing BOOLEAN;