APPS.HXC_RDB_POST_RETRIEVAL dependencies on PAY_BATCH_HEADERS

Line 70: FROM pay_batch_headers pbh

66: ';
67:
68: l_batch_criteria VARCHAR2(2000) :=
69: 'AND ( EXISTS (SELECT 1
70: FROM pay_batch_headers pbh
71: WHERE pbh.batch_id = ret.batch_id
72: AND pbh.batch_reference = ''BATCHREF'' )
73: OR EXISTS (SELECT 1
74: FROM pay_batch_headers pbh

Line 74: FROM pay_batch_headers pbh

70: FROM pay_batch_headers pbh
71: WHERE pbh.batch_id = ret.batch_id
72: AND pbh.batch_reference = ''BATCHREF'' )
73: OR EXISTS (SELECT 1
74: FROM pay_batch_headers pbh
75: WHERE pbh.batch_id = ret.retro_batch_id
76: AND pbh.batch_reference = ''BATCHREF'' )
77: )
78: ';

Line 1562: pay_batch_headers pbh

1558: CURSOR get_batch_name
1559: IS SELECT pbh.batch_name||DECODE(retro_flag,'Y','(Retro)'),
1560: ROWIDTOCHAR(rdb.ROWID)
1561: FROM hxc_rdb_post_batches rdb,
1562: pay_batch_headers pbh
1563: WHERE REPLACE(rdb.batch_id,'(Retro)') = pbh.batch_id
1564: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1565:
1566:

Line 2188: pay_batch_headers pbh

2184: CURSOR get_batch_name
2185: IS SELECT pbh.batch_name,
2186: ROWIDTOCHAR(rdb.ROWID)
2187: FROM hxc_rdb_post_tc_details rdb,
2188: pay_batch_headers pbh
2189: WHERE REPLACE(rdb.batch_id,'(Retro)') = pbh.batch_id
2190: AND rdb.ret_user_id = FND_GLOBAL.user_id;
2191:
2192: CURSOR get_batch_name_old

Line 2196: pay_batch_headers pbh

2192: CURSOR get_batch_name_old
2193: IS SELECT pbh.batch_name,
2194: ROWIDTOCHAR(rdb.ROWID)
2195: FROM hxc_rdb_post_tc_details rdb,
2196: pay_batch_headers pbh
2197: WHERE rdb.old_batch_id = pbh.batch_id
2198: AND rdb.ret_user_id = FND_GLOBAL.user_id;
2199:
2200: