APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on RA_TERMS_B

Line 11294: from ra_terms_b

11290: -- Validate that the payment_term_id passed should be a non Balance Forwarded Billing payment term.
11291: -- Changed as a part of Balance Forwarded Billing enhancement. bug # 4935721
11292: SELECT 'Y'
11293: into l_dummy
11294: from ra_terms_b
11295: where term_id = p_column_value
11296: -- and billing_cycle_id is null
11297: and trunc(sysdate) between
11298: start_date_active and nvl(end_date_active,trunc(sysdate));

Line 11331: from ra_terms_b

11327: if p_cons_inv_flag = 'N' then
11328: begin
11329: SELECT 'Y'
11330: into l_dummy
11331: from ra_terms_b
11332: where term_id = p_column_value
11333: and billing_cycle_id is null
11334: and trunc(sysdate) between
11335: start_date_active and nvl(end_date_active,trunc(sysdate));

Line 11349: from ra_terms_b t

11345: elsif p_cons_inv_flag = 'Y' then
11346: begin
11347: SELECT 'Y'
11348: into l_dummy
11349: from ra_terms_b t
11350: where t.term_id = p_column_value
11351: and t.billing_cycle_id is not null
11352: and trunc(sysdate) between
11353: t.start_date_active and nvl(t.end_date_active,trunc(sysdate));

Line 11830: from ra_terms_b

11826: if p_cons_inv_flag = 'N' then
11827: begin
11828: SELECT 'Y'
11829: into l_dummy
11830: from ra_terms_b
11831: where term_id = p_column_value
11832: -- and billing_cycle_id is null
11833: and trunc(sysdate) between
11834: start_date_active and nvl(end_date_active,trunc(sysdate));

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

11849: */
11850: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11851: FND_MESSAGE.SET_TOKEN( 'FK', 'standard_terms' );
11852: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11853: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_terms_b');
11854: FND_MSG_PUB.ADD;
11855: x_return_status := FND_API.G_RET_STS_ERROR;
11856: end;
11857: elsif p_cons_inv_flag = 'Y' then

Line 11861: from ra_terms_b t

11857: elsif p_cons_inv_flag = 'Y' then
11858: begin
11859: SELECT 'Y'
11860: into l_dummy
11861: from ra_terms_b t
11862: where t.term_id = p_column_value
11863: and t.billing_cycle_id is not null
11864: and trunc(sysdate) between
11865: t.start_date_active and nvl(t.end_date_active,trunc(sysdate));