APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on FND_DATE

Line 1104: 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');

1100: CLOSE csr_get_start_date_cut;
1101: END IF;
1102: ELSE
1103: debug('g_claim_date :' || g_claim_date);
1104: 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');
1105: debug('p_output :' || p_output,99);
1106:
1107: END IF;
1108:

Line 1168: 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');

1164:
1165:
1166: IF g_is_spread_bonus_yn = 'Y' THEN
1167: debug('g_claim_date :' || g_claim_date);
1168: 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');
1169: debug('p_output :' || p_output,99);
1170: END IF;
1171:
1172: debug_exit(l_proc_name);