DBA Data[Home] [Help]

APPS.PQP_USTIAA_PKG dependencies on FND_DATE

Line 1065: load_xml('D','DOB',replace(substr(nvl(fnd_date.date_to_canonical(l_dob),'0'),1,10),'/','-'));

1061: load_xml('D','MODE',l_mode);
1062: load_xml('D','SSN',l_ssn);
1063: load_xml('D','EMP_NAME',l_last_name||','||l_first_name||' '||substr(l_middle_name,1,1));
1064: load_xml('D','GENDER',l_gender);
1065: load_xml('D','DOB',replace(substr(nvl(fnd_date.date_to_canonical(l_dob),'0'),1,10),'/','-'));
1066: load_xml('D','ADD_LINE1',l_addr1);
1067: load_xml('D','ADD_LINE2',l_addr2);
1068: load_xml('D','ADD_LINE3',l_addr3);
1069: load_xml('D','CITY',l_city);

Line 1075: load_xml('D','PAYROLL_DATE',to_char(replace(substr(nvl(fnd_date.date_to_canonical(a.pay_date),'0'),1,10),'/','-')));

1071: load_xml('D','COUNTRY',l_country);
1072: load_xml('D','ZIP',l_postal_code);
1073: load_xml('D','PAYROLL_FREQ',l_pay_freq);
1074: load_xml('D','PERIOD_TYPE',l_period_type);
1075: load_xml('D','PAYROLL_DATE',to_char(replace(substr(nvl(fnd_date.date_to_canonical(a.pay_date),'0'),1,10),'/','-')));
1076: load_xml('D','SOURCE',l_source);
1077: load_xml('D','AMOUNT',round(l_amount,2));
1078: load_xml('D','FMT_AMOUNT',l_fmt_amount);
1079: load_xml('D','SUB_PLAN',l_sub_plan);