APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_BATCH_SOURCES_ALL

Line 1109: FROM ra_batch_sources_all

1105:
1106: BEGIN
1107: SELECT name
1108: INTO l_batch_source_name
1109: FROM ra_batch_sources_all
1110: WHERE batch_source_id = p_in_rec.batch_source_id
1111: AND org_id = l_org_id
1112: AND Trunc(SYSDATE) BETWEEN start_date AND Nvl(end_date,Trunc(SYSDATE+1));
1113: EXCEPTION

Line 4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;

4598: l_batch_source_status ra_batch_sources.STATUS%TYPE;
4599: l_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4600: l_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4601: l_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4602: l_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4603: l_credit_memo_batch_source_id ra_batch_sources.CREDIT_MEMO_BATCH_SOURCE_ID%TYPE;
4604: l_credit_batch_source_name ra_batch_sources.NAME%TYPE;
4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;

Line 4609: l_cr_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;

4605: l_cr_batch_source_status ra_batch_sources.STATUS%TYPE;
4606: l_cr_auto_batch_numbering_flag ra_batch_sources.AUTO_BATCH_NUMBERING_FLAG%TYPE;
4607: l_cr_auto_trx_numbering_flag ra_batch_sources.AUTO_TRX_NUMBERING_FLAG%TYPE;
4608: l_cr_batch_source_type ra_batch_sources.BATCH_SOURCE_TYPE%TYPE;
4609: l_cr_allow_dup_trx_num_flag ra_batch_sources.ALLOW_DUPLICATE_TRX_NUM_FLAG%TYPE;
4610:
4611: l_memo_line_name ar_memo_lines.NAME%TYPE;
4612: l_memo_line_type ar_memo_lines.line_type%TYPE;
4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;

Line 4904: FROM RA_BATCH_SOURCES_ALL

4900: l_auto_trx_numbering_flag,
4901: l_batch_source_type,
4902: l_allow_dup_trx_num_flag,
4903: l_credit_memo_batch_source_id
4904: FROM RA_BATCH_SOURCES_ALL
4905: WHERE BATCH_SOURCE_ID = l_ra_batch_source_id
4906: AND ORG_ID = p_org_id;
4907: EXCEPTION
4908: WHEN No_Data_Found THEN

Line 4961: FROM RA_BATCH_SOURCES_ALL

4957: l_cr_auto_batch_numbering_flag,
4958: l_cr_auto_trx_numbering_flag,
4959: l_cr_batch_source_type,
4960: l_cr_allow_dup_trx_num_flag
4961: FROM RA_BATCH_SOURCES_ALL
4962: WHERE BATCH_SOURCE_ID = l_credit_memo_batch_source_id
4963: AND ORG_ID = p_org_id;
4964: EXCEPTION
4965: WHEN No_Data_Found THEN

Line 5601: FROM ra_batch_sources_all

5597:
5598: BEGIN
5599: SELECT name
5600: INTO l_batch_source_name
5601: FROM ra_batch_sources_all
5602: WHERE batch_source_id = p_in_rec.batch_source_id
5603: AND org_id = p_in_rec.org_id
5604: AND Trunc(SYSDATE) BETWEEN start_date AND Nvl(end_date,Trunc(SYSDATE+1));
5605: EXCEPTION