APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on FND_DATE

Line 1249: p_output := to_char( (fnd_date.canonical_to_date(g_claim_date) + (7 - to_char(fnd_date.canonical_to_date(g_claim_date), 'D')) - 6),'DD/MM/YYYY');

1245: CLOSE csr_get_start_date_cut;
1246: END IF;
1247: ELSE
1248: debug('g_claim_date :' || g_claim_date);
1249: p_output := to_char( (fnd_date.canonical_to_date(g_claim_date) + (7 - to_char(fnd_date.canonical_to_date(g_claim_date), 'D')) - 6),'DD/MM/YYYY');
1250: debug('p_output :' || p_output,99);
1251:
1252: END IF;
1253:

Line 1317: p_output := to_char( fnd_date.canonical_to_date(g_claim_date) + (7 - to_char(fnd_date.canonical_to_date(g_claim_date), 'D')),'DD/MM/YYYY');

1313:
1314:
1315: IF g_is_spread_bonus_yn = 'Y' THEN
1316: debug('g_claim_date :' || g_claim_date);
1317: p_output := to_char( fnd_date.canonical_to_date(g_claim_date) + (7 - to_char(fnd_date.canonical_to_date(g_claim_date), 'D')),'DD/MM/YYYY');
1318: debug('p_output :' || p_output,99);
1319: END IF;
1320:
1321: debug_exit(l_proc_name);