DBA Data[Home] [Help]

APPS.PAY_JP_DEF_REPORT_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 24: -- use in pay_magtape_generic cursor

20: g_remove_act varchar2(1);
21: g_call_type varchar2(30); -- SS, CP
22: --
23: -- -------------------------------------------------------------------------
24: -- use in pay_magtape_generic cursor
25: -- -------------------------------------------------------------------------
26: level_cnt number;
27: --
28: -- -------------------------------------------------------------------------

Line 52: where proc_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

48: lpad(pjde.employee_number,30,' ')) sort
49: from pay_assignment_actions proc_paa,
50: pay_jp_def_assact_v pjda,
51: pay_jp_def_emp_v pjde
52: where proc_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
53: and pjda.assignment_action_id = proc_paa.source_action_id
54: and pjde.assignment_action_id = pjda.assignment_action_id
55: and pjde.effective_date = pjda.effective_date) v
56: order by