APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_PAYROLL_ACTIONS

Line 138: pay_payroll_actions xppa,

134: and choi.organization_id = to_number(hoi.org_information10)
135: and choi.org_information_context = 'KR_CORPORATE_INFORMATION'
136: and exists (select 'x'
137: from pay_assignment_actions xpaa,
138: pay_payroll_actions xppa,
139: ff_Archive_items fai,
140: ff_user_entities fue
141: where xppa.action_type = 'X'
142: and xppa.action_status = 'C'

Line 195: ,pay_payroll_actions xppa

191: ,sum(decode(decode(fue.user_entity_name ,'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_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 281: ,pay_payroll_actions xppa

277: ,xpaa.assignment_id
278: ,'PREVIOUS_EMP_COUNT=P'
279: ,pay_kr_nonstat_spay_efile_fun.get_prev_emp_count(xpaa.assignment_action_id)
280: FROM pay_assignment_actions xpaa
281: ,pay_payroll_actions xppa
282: ,hr_organization_information hoi
283: ,hr_organization_units hou
284: ,ff_user_entities fue
285: ,ff_archive_items fai