DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 79: from pay_assignment_actions proc_paa,

75: decode(pay_jp_itwb_report_pkg.g_sort_order3,
76: 'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
77: 'ORGANIZATION_NAME',pjieas.organization_name,
78: lpad(pjie.employee_number,30,' ')) sort3
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')