APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on RA_TERMS_B

Line 11003: from ra_terms_b

10999: -- Validate that the payment_term_id passed should be a non Balance Forwarded Billing payment term.
11000: -- Changed as a part of Balance Forwarded Billing enhancement. bug # 4935721
11001: SELECT 'Y'
11002: into l_dummy
11003: from ra_terms_b
11004: where term_id = p_column_value
11005: -- and billing_cycle_id is null
11006: and trunc(sysdate) between
11007: start_date_active and nvl(end_date_active,trunc(sysdate));

Line 11040: from ra_terms_b

11036: if p_cons_inv_flag = 'N' then
11037: begin
11038: SELECT 'Y'
11039: into l_dummy
11040: from ra_terms_b
11041: where term_id = p_column_value
11042: and billing_cycle_id is null
11043: and trunc(sysdate) between
11044: start_date_active and nvl(end_date_active,trunc(sysdate));

Line 11058: from ra_terms_b t

11054: elsif p_cons_inv_flag = 'Y' then
11055: begin
11056: SELECT 'Y'
11057: into l_dummy
11058: from ra_terms_b t
11059: where t.term_id = p_column_value
11060: and t.billing_cycle_id is not null
11061: and trunc(sysdate) between
11062: t.start_date_active and nvl(t.end_date_active,trunc(sysdate));

Line 11538: from ra_terms_b

11534: if p_cons_inv_flag = 'N' then
11535: begin
11536: SELECT 'Y'
11537: into l_dummy
11538: from ra_terms_b
11539: where term_id = p_column_value
11540: -- and billing_cycle_id is null
11541: and trunc(sysdate) between
11542: start_date_active and nvl(end_date_active,trunc(sysdate));

Line 11561: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms_b');

11557: */
11558: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11559: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );
11560: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11561: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms_b');
11562: FND_MSG_PUB.ADD;
11563: x_return_status := FND_API.G_RET_STS_ERROR;
11564: end;
11565: elsif p_cons_inv_flag = 'Y' then

Line 11569: from ra_terms_b t

11565: elsif p_cons_inv_flag = 'Y' then
11566: begin
11567: SELECT 'Y'
11568: into l_dummy
11569: from ra_terms_b t
11570: where t.term_id = p_column_value
11571: and t.billing_cycle_id is not null
11572: and trunc(sysdate) between
11573: t.start_date_active and nvl(t.end_date_active,trunc(sysdate));