eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_PAYSLIP_REPORT dependencies on PAY_PAYSLIP_REPORT

Line 47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

43: WHERE ptoa.object_id = paaf.assignment_id
44: AND paaf.person_id = papf.person_id
45: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
46: AND ptoa.payroll_action_id = ppa.payroll_action_id
47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

Line 48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')

44: AND paaf.person_id = papf.person_id
45: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
46: AND ptoa.payroll_action_id = ppa.payroll_action_id
47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
52: between paaf.effective_start_date and paaf.effective_end_date

Line 49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

45: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
46: AND ptoa.payroll_action_id = ppa.payroll_action_id
47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
52: between paaf.effective_start_date and paaf.effective_end_date
53: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

Line 50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')

46: AND ptoa.payroll_action_id = ppa.payroll_action_id
47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
52: between paaf.effective_start_date and paaf.effective_end_date
53: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
54: between papf.effective_start_date and papf.effective_end_date

Line 51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
52: between paaf.effective_start_date and paaf.effective_end_date
53: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
54: between papf.effective_start_date and papf.effective_end_date
55: AND papf.business_group_id = pbg.business_group_id

Line 53: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50: -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
52: between paaf.effective_start_date and paaf.effective_end_date
53: AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
54: between papf.effective_start_date and papf.effective_end_date
55: AND papf.business_group_id = pbg.business_group_id
56: -- AND pbg.legislation_code = NVL(past.legislation_code,pbg.legislation_code)
57: -- AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 65: ORDER BY DECODE(pay_payslip_report.get_sort_order('LE',pbg.legislation_code)

61: -- AND ppt.business_group_id = pbg.business_group_id
62: -- AND ppt.active_flag = 'Y'
63: -- AND ppt.system_person_type = 'EMP'
64: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
65: ORDER BY DECODE(pay_payslip_report.get_sort_order('LE',pbg.legislation_code)
66: ,'SEGMENT1',hsck.segment1
67: ,'SEGMENT2',hsck.segment2
68: ,'SEGMENT3',hsck.segment3
69: ,'SEGMENT4',hsck.segment4

Line 96: ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)

92: ,'SEGMENT27',hsck.segment27
93: ,'SEGMENT28',hsck.segment28
94: ,'SEGMENT29',hsck.segment29
95: ,'SEGMENT30',hsck.segment30)
96: ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)
97: ,'ORGANIZATION_ID',paaf.organization_id
98: ,'ASSIGNMENT_NUMBER',paaf.assignment_number)
99: ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)
100: ,'LAST_NAME',papf.last_name

Line 99: ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)

95: ,'SEGMENT30',hsck.segment30)
96: ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)
97: ,'ORGANIZATION_ID',paaf.organization_id
98: ,'ASSIGNMENT_NUMBER',paaf.assignment_number)
99: ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)
100: ,'LAST_NAME',papf.last_name
101: ,'FIRST_NAME',papf.first_name
102: ,'FULL_NAME',papf.full_name
103: ,papf.last_name)