APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 38: PAY_PAYROLL_ACTIONS ppa

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

Line 85: , PAY_PAYROLL_ACTIONS ppa

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