DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 45: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

41: ,hr_organization_information hoi2
42: ,hr_organization_information hoi3
43: ,hr_organization_information hoi4
44: ,HR_LOCATIONS_ALL HL
45: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: AND ou.organization_id = PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG')
47: and ou.business_group_id = ppa.business_group_id
48: AND hoi1.organization_id = ou.organization_id
49: AND hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 86: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

82: , HR_SOFT_CODING_KEYFLEX scl
83: , PER_ALL_PEOPLE_F pap
84: , PER_ALL_ASSIGNMENTS_F paa
85: , PAY_PAYROLL_ACTIONS ppa
86: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
87: and hoi1.organization_id = decode(pay_se_tax_card_req_pkg.get_parameter(ppa.legislative_parameters, 'REQUEST_FOR'),'ALL_ORG',hoi1.organization_id,pay_se_tax_card_req_pkg.get_parameter(ppa.legislative_parameters, 'REQUESTING_ORG'))
88: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
89: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
90: and hoi2.organization_id = hoi1.organization_id