DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on PAY_MAGTAPE_GENERIC

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

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

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

81: , HR_SOFT_CODING_KEYFLEX scl
82: , PER_ALL_PEOPLE_F pap
83: , PER_ALL_ASSIGNMENTS_F paa
84: , PAY_PAYROLL_ACTIONS ppa
85: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
86: 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'))
87: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
88: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
89: and hoi2.organization_id = hoi1.organization_id