APPS.PAY_KR_SPAY_EFILE dependencies on PAY_PAYROLL_ACTIONS

Line 13: ,pay_payroll_actions xppa

9: ,count(distinct hoi.org_information2||ihoi.org_information9) bp_count
10: ,'CORPORATION_ID=P'
11: ,hoi.org_information10
12: FROM pay_assignment_actions xpaa
13: ,pay_payroll_actions xppa
14: ,hr_organization_information hoi
15: ,hr_organization_units hou
16: ,hr_organization_units phou
17: ,hr_organization_information phoi

Line 105: ,pay_payroll_actions xppa

101: and hla.style(+) = 'KR'
102: -- Bug 4272920
103: and hou.organization_id = (select xpaa.tax_unit_id
104: from pay_assignment_actions xpaa
105: ,pay_payroll_actions xppa
106: where xppa.action_type = 'X'
107: and xppa.action_status = 'C'
108: and xppa.effective_date between pay_magtape_generic.get_parameter_value('START_DATE')
109: and pay_magtape_generic.get_parameter_value('END_DATE')

Line 133: ,pay_payroll_actions xppa

129: hoi.org_information2,
130: 'TAX_OFFICE_CODE=P',
131: ihoi.org_information9
132: FROM pay_assignment_actions xpaa
133: ,pay_payroll_actions xppa
134: ,hr_organization_information hoi
135: ,hr_organization_information ihoi
136: WHERE xppa.action_type = 'X'
137: and xppa.action_status = 'C'

Line 195: ,pay_payroll_actions xppa

191: ,sum(decode(decode(fue.user_entity_name ,'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN',fai.value,0),0,0,1)) EMPCOUNT
192: ,'PREV_EMP_COUNT=P'
193: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
194: FROM pay_assignment_actions xpaa
195: ,pay_payroll_actions xppa
196: ,hr_organization_information hoi
197: ,hr_organization_information ihoi
198: ,hr_organization_units hou
199: ,ff_user_entities fue

Line 250: ,pay_payroll_actions xppa

246: is
247: SELECT 'ASSIGNMENT_ACTION_ID=C'
248: ,max(xpaa.assignment_action_id)
249: FROM pay_assignment_actions xpaa
250: ,pay_payroll_actions xppa
251: ,hr_organization_information hoi
252: ,hr_organization_information ihoi
253: ,hr_organization_units hou
254: WHERE xppa.action_type = 'X'

Line 306: ,pay_payroll_actions ppa

302: -- End of 4201616
303: ,fai.value
304: -- Bug 4201616
305: FROM pay_assignment_actions paa
306: ,pay_payroll_actions ppa
307: ,pay_action_interlocks pai
308: ,pay_run_types prt
309: -- End of 4201616
310: ,pay_assignment_actions xpaa

Line 311: ,pay_payroll_actions xppa

307: ,pay_action_interlocks pai
308: ,pay_run_types prt
309: -- End of 4201616
310: ,pay_assignment_actions xpaa
311: ,pay_payroll_actions xppa
312: ,hr_organization_information hoi
313: ,hr_organization_information ihoi
314: ,hr_organization_units hou
315: ,ff_user_entities fue