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 997: FROM ar_aging_buckets a,

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

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

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