DBA Data[Home] [Help]

APPS.PAY_PYNZREC_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 25: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

21: v_lookup_type fnd_lookups.lookup_type%type := 'ACTION_TYPE';
22: v_display varchar2(100) := null;
23:
24: cursor payroll_run
25: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
26: select pap.payroll_name || ' - ' ||
27: ptp.period_name || ' (' ||
28: fcl.meaning || ' ' ||
29: to_char(ppa.display_run_number) || ')' display

Line 32: pay_payroll_actions ppa,

28: fcl.meaning || ' ' ||
29: to_char(ppa.display_run_number) || ')' display
30: from pay_all_payrolls_f pap,
31: per_time_periods ptp,
32: pay_payroll_actions ppa,
33: hr_lookups fcl
34: where ppa.payroll_action_id = c_payroll_action_id
35: and pap.payroll_id = ppa.payroll_id
36: and ppa.payroll_id = ptp.payroll_id