DBA Data[Home] [Help]

APPS.AR_CHARGE_SCHEDULE_PKG dependencies on AR_AGING_BUCKETS

Line 703: FROM ar_aging_buckets

699: WHERE schedule_id = p_schedule_id;
700:
701: CURSOR c_aging_bucket IS
702: SELECT NULL
703: FROM ar_aging_buckets
704: WHERE aging_bucket_id = P_AGING_BUCKET_ID;
705:
706: CURSOR c_overlapp IS
707: SELECT start_date,

Line 995: FROM ar_aging_buckets a,

991:
992: CURSOR c_aging_bucket_id(p_aging_bucket_id IN NUMBER,
993: p_aging_bucket_line_id IN NUMBER) IS
994: SELECT NULL
995: FROM ar_aging_buckets a,
996: ar_aging_bucket_lines_b b
997: WHERE a.aging_bucket_id = p_aging_bucket_id
998: AND a.status = 'A'
999: AND a.aging_bucket_id = b.aging_bucket_id

Line 1138: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');

1134: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1135: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1136: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_id' );
1137: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_id' );
1138: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_buckets');
1139: FND_MSG_PUB.ADD;
1140: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
1141: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1142: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );