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_DK_MIA_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 70: , PAY_PAYROLL_ACTIONS ppa

66: FROM HR_ORGANIZATION_UNITS hou1
67: , HR_ORGANIZATION_INFORMATION hoi1
68: , HR_ORGANIZATION_INFORMATION hoi2
69: , HR_LOCATIONS loc
70: , PAY_PAYROLL_ACTIONS ppa
71: WHERE
72: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
73: and hou1.business_group_id = ppa.BUSINESS_GROUP_ID
74: and hou1.organization_id = nvl(PAY_DK_MIA_REPORT_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),hou1.organization_id)

Line 106: , pay_payroll_actions PPA

102: per_all_people_f PAP
103: , per_all_assignments_f PAA
104: , pay_assignment_actions pact
105: , pay_payrolls_f PPF
106: , pay_payroll_actions PPA
107: , per_periods_of_service PPS
108: , hr_soft_coding_keyflex SCL
109: , HR_ORGANIZATION_UNITS hou
110: , HR_ORGANIZATION_INFORMATION hoi1

Line 122: AND pact.payroll_action_id = (select max(payroll_action_id) from pay_payroll_actions

118: AND PPS.person_id = PAP.person_id
119: AND PAA.payroll_id = PPF.payroll_id
120: AND PAA.PAYROLL_ID > 0
121: AND PAA.payroll_id = PPA.payroll_id
122: AND pact.payroll_action_id = (select max(payroll_action_id) from pay_payroll_actions
123: where payroll_id=PPA.payroll_id
124: and action_type='R'
125: and action_status ='C'
126: and effective_date BETWEEN ppa.start_date AND ppa.effective_date)

Line 128: (select '1' from pay_payroll_actions

124: and action_type='R'
125: and action_status ='C'
126: and effective_date BETWEEN ppa.start_date AND ppa.effective_date)
127: and exists
128: (select '1' from pay_payroll_actions
129: where payroll_id=PPA.payroll_id
130: and action_type='P'
131: and action_status = 'C'
132: and effective_date BETWEEN ppa.start_date AND ppa.effective_date)

Line 139: to_char((select effective_date from pay_payroll_actions

135: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
136: --AND PPA.EFFECTIVE_DATE between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
137: AND PPA.EFFECTIVE_DATE between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
138: AND to_char(PPA.effective_date,'YYYYMMDD') =
139: to_char((select effective_date from pay_payroll_actions
140: where payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')),'YYYYMMDD')
141: AND PPA.EFFECTIVE_DATE BETWEEN PPS.DATE_START AND NVL(PPS.ACTUAL_TERMINATION_DATE,TO_DATE('31/12/4712','dd/mm/yyyy'))--Check added by pgopal for bug fix-4499107
142: and hou.business_group_id = PPA.business_group_id
143: and hoi1.organization_id = hou.organization_id