DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on HR_GENERAL

Line 33: ,'POST_OFFICE=P', RPAD(nvl(hr_general.DECODE_LOOKUP('SE_POSTAL_CODE',HL.POSTAL_CODE),' '),15,' ') /*ORTAF*/

29: ,'EMPLOYER_NAME=P', RPAD(NVL(substr(ou.name,1,30),' '),30,' ') /*NAMNF*/
30: ,'CONTACT_PERSON=P', RPAD(NVL(substr(hoi3.org_information3,1,30),' '),30,' ') /*AVDF */
31: ,'ADDRESS1=P', RPAD(NVL(substr(HL.ADDRESS_LINE_1||decode(HL.ADDRESS_LINE_1,NULL,'',',')|| HL.ADDRESS_LINE_2|| decode(HL.ADDRESS_LINE_2,NULL,'',',') ||HL.ADDRESS_LINE_3,1,30),' '),30,' ') /*ADRF*/
32: ,'POSTAL_CODE=P', RPAD(NVL(substr(hl.Postal_code,1,5),' '),5,' ') /*PONRF*/
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