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 194: FROM pay_assignment_actions xpaa

190: ,'EMPLOYEE_COUNT=P'
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

Line 249: FROM pay_assignment_actions xpaa

245: cursor c_sep_tax_B_detail
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

Line 305: FROM pay_assignment_actions paa

301: ,fnd_date.date_to_canonical(ppa.effective_date)
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

Line 310: ,pay_assignment_actions xpaa

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