DBA Data[Home] [Help]

APPS.JTF_TERR_LOOKUP_PUB dependencies on JTY_TERR_1001_ACCOUNT_TRANS_GT

Line 725: DELETE jty_terr_1001_account_trans_gt;

721: -- this package too.
722: IF ( p_source_id = -1001 AND p_trans_id = -1002) THEN
723: l_program_name := 'SALES/ACCOUNT PROGRAM';
724:
725: DELETE jty_terr_1001_account_trans_gt;
726:
727: FORALL i IN lp_trans_rec.trans_object_id.FIRST .. lp_trans_rec.trans_object_id.LAST
728: INSERT INTO jty_terr_1001_account_trans_gt (
729: TRANS_OBJECT_ID

Line 728: INSERT INTO jty_terr_1001_account_trans_gt (

724:
725: DELETE jty_terr_1001_account_trans_gt;
726:
727: FORALL i IN lp_trans_rec.trans_object_id.FIRST .. lp_trans_rec.trans_object_id.LAST
728: INSERT INTO jty_terr_1001_account_trans_gt (
729: TRANS_OBJECT_ID
730: ,TRANS_DETAIL_OBJECT_ID
731: ,COMP_NAME_RANGE
732: ,POSTAL_CODE