DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 143: from pay_assignment_actions xpaa,

139: )
140: and choi.organization_id = to_number(hoi.org_information10)
141: and choi.org_information_context = 'KR_CORPORATE_INFORMATION'
142: and exists (select 'x'
143: from pay_assignment_actions xpaa,
144: pay_payroll_actions xppa,
145: ff_Archive_items fai,
146: ff_user_entities fue
147: where xppa.action_type = 'X'

Line 255: FROM pay_assignment_actions xpaa

251: ,'PREV_EMP_COUNT=P'
252: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
253: ,'REPORTING_PERIOD=P'
254: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
255: FROM pay_assignment_actions xpaa
256: ,pay_payroll_actions xppa
257: ,hr_organization_information hoi
258: ,hr_organization_information ihoi
259: ,hr_organization_units hou

Line 398: FROM pay_assignment_actions xpaa

394: ,'EFFECTIVE_DATE=P'
395: ,to_char(xppa.effective_date,'YYYY/MM/DD')
396:
397:
398: FROM pay_assignment_actions xpaa
399: ,pay_payroll_actions xppa
400: ,hr_organization_information hoi
401: ,hr_organization_units hou
402: ,ff_user_entities fue