APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 37: PAY_PAYROLL_ACTIONS ppa

33: ,'POST_OFFICE=P', RPAD(nvl(hr_general.DECODE_LOOKUP('SE_POSTAL_CODE',HL.POSTAL_CODE),' '),15,' ') /*ORTAF*/
34: ,'PHONE=P', RPAD(NVL(substr(hoi4.org_information3,1,10),' '),10,' ') /*TELEF*/
35: ,'TEST_RUN=P', DECODE(pay_se_tax_card_req_pkg.get_parameter(ppa.legislative_parameters, 'TEST_RUN'),'Y','T',' ')
36: from
37: PAY_PAYROLL_ACTIONS ppa
38: ,hr_organization_units ou
39: ,hr_organization_information hoi1
40: ,hr_organization_information hoi2
41: ,hr_organization_information hoi3

Line 84: , PAY_PAYROLL_ACTIONS ppa

80: , PAY_LEGISLATION_RULES plr
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'