DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on FND_PROFILE

Line 383: if(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = '1') then

379: /*
380: If profile option set to last receipt date, then use the last receipt date
381: to calculate Age in Days unless it is null, then use last invoice date
382: */
383: if(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = '1') then
384: --{
385: if(p_lrd is not null) then
386: --{
387: x_count := trunc(sysdate - p_lrd);

Line 430: end if; /* fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = 1 */

426: end if; /* p_lrd >= p_lid */
427: --}
428: end if; /* p_lid is null, p_lrd is null */
429: --}
430: end if; /* fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = 1 */
431:
432: exception
433: when others then
434: --{

Line 506: if(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = '1') then

502: /*
503: If profile option set to last receipt date, then use the last receipt date
504: to calculate Age in Days unless it is null, then use last invoice date
505: */
506: if(fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = '1') then
507: --{
508: if(p_lrd is not null) then
509: --{
510: return trunc(sysdate - p_lrd);

Line 547: end if; /* fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = 1 */

543: end if; /* p_lrd >= p_lid */
544: --}
545: end if; /* p_lid is null, p_lrd is null */
546: --}
547: end if; /* fnd_profile.value('CST_ACCRUAL_AGE_IN_DAYS') = 1 */
548:
549: exception
550: when others then
551: --{