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 196: ,pay_payroll_actions xppa

192: pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),0),0,0,1)) EMPCOUNT --Bug 9409509
193: ,'PREV_EMP_COUNT=P'
194: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
195: FROM pay_assignment_actions xpaa
196: ,pay_payroll_actions xppa
197: ,hr_organization_information hoi
198: ,hr_organization_information ihoi
199: ,hr_organization_units hou
200: ,ff_user_entities fue

Line 253: ,pay_payroll_actions xppa

249: ,max(xpaa.assignment_action_id)
250: ,'REPORTING_PERIOD=P'
251: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
252: FROM pay_assignment_actions xpaa
253: ,pay_payroll_actions xppa
254: ,hr_organization_information hoi
255: ,hr_organization_information ihoi
256: ,hr_organization_units hou
257: WHERE xppa.action_type = 'X'

Line 313: ,pay_payroll_actions ppa

309: -- End of 4201616
310: ,fai.value
311: -- Bug 4201616
312: FROM pay_assignment_actions paa
313: ,pay_payroll_actions ppa
314: ,pay_action_interlocks pai
315: ,pay_run_types prt
316: -- End of 4201616
317: ,pay_assignment_actions xpaa

Line 318: ,pay_payroll_actions xppa

314: ,pay_action_interlocks pai
315: ,pay_run_types prt
316: -- End of 4201616
317: ,pay_assignment_actions xpaa
318: ,pay_payroll_actions xppa
319: ,hr_organization_information hoi
320: ,hr_organization_information ihoi
321: ,hr_organization_units hou
322: ,ff_user_entities fue