APPS.PAY_MX_FF_UDFS dependencies on PAY_PAYROLL_ACTIONS

Line 1120: pay_payroll_actions pa

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*/
1124: AND pa.action_type IN ('R','Q')

Line 1977: FUNCTION get_date_paid(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

1973: RAISE;
1974: END get_base_pay_for_tax_calc;
1975:
1976: /* GET_PAY_DATE FUNCTION */
1977: FUNCTION get_date_paid(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1978:
1979: RETURN DATE IS
1980: ln_date_paid DATE ;
1981:

Line 1985: INTO ln_date_paid from pay_payroll_actions

1981:
1982: BEGIN
1983:
1984: SELECT effective_date
1985: INTO ln_date_paid from pay_payroll_actions
1986: WHERE payroll_action_id=p_payroll_action_id;
1987:
1988:
1989: hr_utility.trace('assignment date paid '||ln_date_paid);