DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_PAYROLL_ACTIONS

Line 144: pay_payroll_actions xppa,

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'
148: and xppa.action_status = 'C'

Line 256: ,pay_payroll_actions xppa

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
260: ,ff_user_entities fue

Line 399: ,pay_payroll_actions xppa

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
403: ,ff_archive_items fai