DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on HR_GENERAL

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

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: -- Bug#8849455 fix Added space between 3 and 4 digits in postal code
33: ,'POSTAL_CODE=P', RPAD(NVL(substr(hl.Postal_code,1,3)||' '||substr(hl.Postal_code,4,2),' '),7,' ') /*PONRF*/
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