APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 137: from pay_assignment_actions xpaa,

133: )
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'

Line 194: FROM pay_assignment_actions xpaa

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

Line 280: FROM pay_assignment_actions xpaa

276: ,'ASG_ID=P'
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