APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_BATCH_SOURCES

Line 893: FROM ra_batch_sources

889: ELSIF ( p_entity = 'BATCH_SOURCE_NAME' )
890: THEN
891: SELECT batch_source_id
892: INTO l_selected_id
893: FROM ra_batch_sources
894: WHERE name = p_value and
895: nvl(status, 'A') = 'A' and (batch_source_type = 'INV');
896: ELSIF ( p_entity = 'TERM_NAME' )
897: THEN

Line 1388: p_batch_source_name IN ra_batch_sources.name%type,

1384: p_salesrep_name IN VARCHAR2 DEFAULT NULL,
1385: x_term_id IN OUT NOCOPY NUMBER ,
1386: p_term_name IN VARCHAR2 DEFAULT NULL,
1387: x_batch_source_id IN OUT NOCOPY NUMBER,
1388: p_batch_source_name IN ra_batch_sources.name%type,
1389: x_cust_trx_type_id IN OUT NOCOPY NUMBER,
1390: p_cust_trx_type IN varchar2,
1391: x_bill_to_customer_id IN OUT NOCOPY NUMBER,
1392: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

Line 1628: FROM ra_batch_sources

1624:
1625: begin
1626: /* SELECT batch_source_id
1627: INTO x_batch_source_id
1628: FROM ra_batch_sources
1629: WHERE name = p_batch_source_name and
1630: batch_source_id not in (11,12) and
1631: nvl(status,'A')= 'A' and (batch_source_type = 'INV');*/
1632: SELECT batch_source_id

Line 1634: FROM ra_batch_sources bs

1630: batch_source_id not in (11,12) and
1631: nvl(status,'A')= 'A' and (batch_source_type = 'INV');*/
1632: SELECT batch_source_id
1633: INTO x_batch_source_id
1634: FROM ra_batch_sources bs
1635: WHERE name = p_batch_source_name and
1636: batch_source_id not in (11,12) and
1637: nvl(status,'A')= 'A' and (batch_source_type = 'INV') and
1638: (( p_deposit_number is not null and

Line 1667: FROM ra_batch_sources

1663:
1664: begin
1665: /* SELECT batch_source_id
1666: INTO l_dummy
1667: FROM ra_batch_sources
1668: WHERE batch_source_id = x_batch_source_id and
1669: batch_source_id not in (11,12) and
1670: nvl(status,'A')= 'A' and (batch_source_type = 'INV');*/
1671: SELECT batch_source_id

Line 1673: FROM ra_batch_sources bs

1669: batch_source_id not in (11,12) and
1670: nvl(status,'A')= 'A' and (batch_source_type = 'INV');*/
1671: SELECT batch_source_id
1672: INTO l_dummy
1673: FROM ra_batch_sources bs
1674: WHERE batch_source_id = x_batch_source_id and
1675: batch_source_id not in (11,12) and
1676: nvl(status,'A')= 'A' and (batch_source_type = 'INV') and
1677: (( p_deposit_number is not null and