APPS.PAY_MX_FF_UDFS dependencies on PAY_ASSIGNMENT_ACTIONS

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

1111: AND p_effective_date BETWEEN b.effective_start_date
1112: AND b.effective_end_date;
1113:
1114: CURSOR
1115: c_get_last_idw_action(cp_asg_id pay_assignment_actions.assignment_id%TYPE,
1116: cp_idw_report_date DATE,
1117: cp_idw_start_date DATE) IS
1118: SELECT assignment_action_id
1119: FROM pay_assignment_actions aa,

Line 1119: FROM pay_assignment_actions aa,

1115: c_get_last_idw_action(cp_asg_id pay_assignment_actions.assignment_id%TYPE,
1116: cp_idw_report_date DATE,
1117: cp_idw_start_date DATE) IS
1118: SELECT assignment_action_id
1119: FROM pay_assignment_actions aa,
1120: pay_payroll_actions pa
1121: WHERE assignment_id = cp_asg_id
1122: AND tax_unit_id = p_tax_unit_id
1123: /*Bug#9386250,9495744 : Changes start here*/

Line 1186: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;

1182:
1183: rn_idw NUMBER;
1184: ln_rate NUMBER;
1185: ln_variable_idw NUMBER;
1186: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;
1187: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;
1188: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1189: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1190: lb_gre_ambiguous BOOLEAN;

Line 1187: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;

1183: rn_idw NUMBER;
1184: ln_rate NUMBER;
1185: ln_variable_idw NUMBER;
1186: ln_last_idw_action pay_assignment_actions.assignment_action_id%TYPE;
1187: ln_asg_tuid pay_assignment_actions.tax_unit_id%TYPE;
1188: ln_idw_ele_id pay_element_types_f.element_type_id%TYPE;
1189: ln_idw_inp_id pay_input_values_f.input_value_id%TYPE;
1190: lb_gre_ambiguous BOOLEAN;
1191: lb_gre_missing BOOLEAN;