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 46: AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

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

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

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

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

44: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
45: AND ptoa.payroll_action_id = ppa.payroll_action_id
46: AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
47: AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
48: AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
49: AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
50: AND papf.business_group_id = pbg.business_group_id
51: AND pbg.legislation_code = NVL(past.legislation_code,pbg.legislation_code)
52: AND past.per_system_status = 'ACTIVE_ASSIGN'

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

45: AND ptoa.payroll_action_id = ppa.payroll_action_id
46: AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
47: AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
48: AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
49: AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
50: AND papf.business_group_id = pbg.business_group_id
51: AND pbg.legislation_code = NVL(past.legislation_code,pbg.legislation_code)
52: AND past.per_system_status = 'ACTIVE_ASSIGN'
53: AND past.active_flag = 'Y'

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

56: AND ppt.business_group_id = pbg.business_group_id
57: AND ppt.active_flag = 'Y'
58: AND ppt.system_person_type = 'EMP'
59: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
60: ORDER BY DECODE(pay_payslip_report.get_sort_order('LE',pbg.legislation_code)
61: ,'SEGMENT1',hsck.segment1
62: ,'SEGMENT2',hsck.segment2
63: ,'SEGMENT3',hsck.segment3
64: ,'SEGMENT4',hsck.segment4

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

87: ,'SEGMENT27',hsck.segment27
88: ,'SEGMENT28',hsck.segment28
89: ,'SEGMENT29',hsck.segment29
90: ,'SEGMENT30',hsck.segment30)
91: ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)
92: ,'ORGANIZATION_ID',paaf.organization_id
93: ,'ASSIGNMENT_NUMBER',paaf.assignment_number)
94: ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)
95: ,'LAST_NAME',papf.last_name

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

90: ,'SEGMENT30',hsck.segment30)
91: ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)
92: ,'ORGANIZATION_ID',paaf.organization_id
93: ,'ASSIGNMENT_NUMBER',paaf.assignment_number)
94: ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)
95: ,'LAST_NAME',papf.last_name
96: ,'FIRST_NAME',papf.first_name
97: ,'FULL_NAME',papf.full_name
98: ,papf.last_name)