APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on FND_DATE

Line 27: ,'REQUEST_DATE=P', to_char(fnd_date.CANONICAL_TO_DATE(PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'EFFECTIVE_DATE')), 'YYYYMMDD') /*DATUMF*/

23: * Cursor to fetch Body record information *
24: ********************************************************/
25: CURSOR CSR_SE_HEAD
26: IS select 'ORG_NUM=P', RPAD(hoi2.org_information2,12) /*ORGNRF*/
27: ,'REQUEST_DATE=P', to_char(fnd_date.CANONICAL_TO_DATE(PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'EFFECTIVE_DATE')), 'YYYYMMDD') /*DATUMF*/
28: ,'TIME_STAMP=P', to_char(fnd_date.CANONICAL_TO_DATE(PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'EFFECTIVE_DATE')),'HH24MISS') /*KLOCKF*/
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*/

Line 28: ,'TIME_STAMP=P', to_char(fnd_date.CANONICAL_TO_DATE(PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'EFFECTIVE_DATE')),'HH24MISS') /*KLOCKF*/

24: ********************************************************/
25: CURSOR CSR_SE_HEAD
26: IS select 'ORG_NUM=P', RPAD(hoi2.org_information2,12) /*ORGNRF*/
27: ,'REQUEST_DATE=P', to_char(fnd_date.CANONICAL_TO_DATE(PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'EFFECTIVE_DATE')), 'YYYYMMDD') /*DATUMF*/
28: ,'TIME_STAMP=P', to_char(fnd_date.CANONICAL_TO_DATE(PAY_SE_TAX_CARD_REQ_PKG.get_parameter(ppa.legislative_parameters, 'EFFECTIVE_DATE')),'HH24MISS') /*KLOCKF*/
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: -- Bug#8849455 fix Added space between 3 and 4 digits in postal code