APPS.JTF_TASK_PARTY_MERGE_PKG dependencies on HZ_MERGE_BATCH

Line 42: from hz_merge_batch

38: l_merge_reason_code VARCHAR2(30);
39:
40: Cursor c_duplicate Is
41: select merge_reason_code
42: from hz_merge_batch
43: where batch_id = p_batch_id;
44:
45:
46: BEGIN

Line 126: from hz_merge_batch

122: l_merge_reason_code VARCHAR2(30);
123:
124: Cursor c_duplicate Is
125: select merge_reason_code
126: from hz_merge_batch
127: where batch_id = p_batch_id;
128:
129:
130: BEGIN

Line 209: from hz_merge_batch

205: l_merge_reason_code VARCHAR2(30);
206:
207: Cursor c_duplicate Is
208: select merge_reason_code
209: from hz_merge_batch
210: where batch_id = p_batch_id;
211:
212:
213: BEGIN

Line 290: from hz_merge_batch

286: l_merge_reason_code VARCHAR2(30);
287:
288: Cursor c_duplicate Is
289: select merge_reason_code
290: from hz_merge_batch
291: where batch_id = p_batch_id;
292:
293: --Cursor c_name Is
294: --select o.select_name

Line 415: from hz_merge_batch

411: l_merge_reason_code VARCHAR2(30);
412:
413: Cursor c_duplicate Is
414: select merge_reason_code
415: from hz_merge_batch
416: where batch_id = p_batch_id;
417:
418: --Cursor c_name Is
419: --select o.select_name

Line 537: from hz_merge_batch

533: l_merge_reason_code VARCHAR2(30);
534:
535: Cursor c_duplicate Is
536: select merge_reason_code
537: from hz_merge_batch
538: where batch_id = p_batch_id;
539:
540: --Cursor c_name Is
541: --select o.select_name

Line 662: from hz_merge_batch

658: l_merge_reason_code VARCHAR2(30);
659:
660: Cursor c_duplicate Is
661: select merge_reason_code
662: from hz_merge_batch
663: where batch_id = p_batch_id;
664:
665: --Cursor c_name Is
666: --select o.select_name

Line 786: from hz_merge_batch

782: l_merge_reason_code VARCHAR2(30);
783:
784: Cursor c_duplicate Is
785: select merge_reason_code
786: from hz_merge_batch
787: where batch_id = p_batch_id;
788:
789: --Cursor c_name Is
790: --select o.select_name

Line 914: from hz_merge_batch

910: l_merge_reason_code VARCHAR2(30);
911:
912: Cursor c_duplicate Is
913: select merge_reason_code
914: from hz_merge_batch
915: where batch_id = p_batch_id;
916:
917:
918: BEGIN

Line 999: from hz_merge_batch

995: l_merge_reason_code VARCHAR2(30);
996:
997: Cursor c_duplicate Is
998: select merge_reason_code
999: from hz_merge_batch
1000: where batch_id = p_batch_id;
1001:
1002:
1003: BEGIN

Line 1084: from hz_merge_batch

1080: l_merge_reason_code VARCHAR2(30);
1081:
1082: Cursor c_duplicate Is
1083: select merge_reason_code
1084: from hz_merge_batch
1085: where batch_id = p_batch_id;
1086:
1087:
1088: BEGIN

Line 1169: from hz_merge_batch

1165: l_merge_reason_code VARCHAR2(30);
1166:
1167: Cursor c_duplicate Is
1168: select merge_reason_code
1169: from hz_merge_batch
1170: where batch_id = p_batch_id;
1171:
1172: BEGIN
1173:

Line 1255: from hz_merge_batch

1251: l_merge_reason_code VARCHAR2(30);
1252:
1253: Cursor c_duplicate Is
1254: select merge_reason_code
1255: from hz_merge_batch
1256: where batch_id = p_batch_id;
1257:
1258: BEGIN
1259:

Line 1341: from hz_merge_batch

1337: l_merge_reason_code VARCHAR2(30);
1338:
1339: Cursor c_duplicate Is
1340: select merge_reason_code
1341: from hz_merge_batch
1342: where batch_id = p_batch_id;
1343:
1344:
1345:

Line 1501: from hz_merge_batch

1497: l_merge_reason_code VARCHAR2(30);
1498:
1499: Cursor c_duplicate Is
1500: select merge_reason_code
1501: from hz_merge_batch
1502: where batch_id = p_batch_id;
1503:
1504:
1505:

Line 1677: from hz_merge_batch

1673: l_merge_reason_code VARCHAR2(30);
1674:
1675: Cursor c_duplicate Is
1676: select merge_reason_code
1677: from hz_merge_batch
1678: where batch_id = p_batch_id;
1679:
1680: CURSOR c_party IS
1681: SELECT party_type