DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_REPORT_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 45: -- use in pay_magtape_generic cursor

41: g_remove_act varchar2(1);
42: g_msg_nres varchar2(80);
43: --
44: -- -------------------------------------------------------------------------
45: -- use in pay_magtape_generic cursor
46: -- -------------------------------------------------------------------------
47: level_cnt number;
48: --
49: -- -------------------------------------------------------------------------

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

79: from pay_assignment_actions proc_paa,
80: pay_jp_itwb_assact_latest_v pjia,
81: pay_jp_itwb_emp_v pjie,
82: pay_jp_itwb_emp_ass_v pjieas
83: where proc_paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
84: and pjia.assignment_action_id = proc_paa.source_action_id
85: and pjie.assignment_action_id = pjia.assignment_action_id
86: and pjie.effective_date = pjia.effective_date
87: and pjieas.assignment_action_id = pjia.assignment_action_id