DBA Data[Home] [Help]

APPS.PAY_DK_TAX_CARD_REQUEST_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 33: , PAY_PAYROLL_ACTIONS ppa

29: FROM HR_ORGANIZATION_UNITS hou1
30: , HR_ORGANIZATION_INFORMATION hoi1
31: , HR_ORGANIZATION_INFORMATION hoi2
32: , HR_LOCATIONS loc
33: , PAY_PAYROLL_ACTIONS ppa
34: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
35: and hou1.business_group_id = ppa.BUSINESS_GROUP_ID
36: and hou1.organization_id = nvl(PAY_DK_TAX_CARD_REQUEST_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),hou1.organization_id)
37: and hou1.location_id = loc.LOCATION_ID(+)

Line 53: , pay_payroll_actions PPA

49: SELECT distinct('CPR_NO=P'), to_char(PAP.NATIONAL_IDENTIFIER), 'EMP_NO=P',to_char(PAP.EMPLOYEE_NUMBER) , 'LEGAL_EMPLR_CVRNO=P', hoi2.ORG_INFORMATION1
50: FROM per_all_assignments_f PAA
51: , per_all_people_f PAP
52: , hr_soft_coding_keyflex SCL
53: , pay_payroll_actions PPA
54: , HR_ORGANIZATION_UNITS hou
55: , HR_ORGANIZATION_INFORMATION hoi1
56: , HR_ORGANIZATION_INFORMATION hoi2
57: WHERE PPA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')