APPS.PAY_KR_SPAY_EFILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 12: FROM pay_assignment_actions xpaa

8: SELECT 'BP_COUNT=P'
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

Line 104: from pay_assignment_actions xpaa

100: and hla.location_id(+) = hou.location_id
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')

Line 132: FROM pay_assignment_actions xpaa

128: SELECT distinct 'BP_NUMBER=P',
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'

Line 195: FROM pay_assignment_actions xpaa

191: ,sum(decode(decode(fue.user_entity_name ,'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN',
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

Line 252: FROM pay_assignment_actions xpaa

248: SELECT 'ASSIGNMENT_ACTION_ID=C'
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

Line 312: FROM pay_assignment_actions paa

308: ,hoi.org_information1
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

Line 317: ,pay_assignment_actions xpaa

313: ,pay_payroll_actions ppa
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