APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on DUAL

Line 257: USING ( SELECT p_terr_id terr_id from dual ) S

253: END IF;
254: ELSIF (Trigger_Mode = 'ON-DELETE') THEN
255:
256: MERGE INTO jty_changed_terrs A
257: USING ( SELECT p_terr_id terr_id from dual ) S
258: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
259: WHEN MATCHED THEN
260: UPDATE SET
261: A.rank_calc_flag = 'N'

Line 657: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S

653: IS
654: BEGIN
655: IF (triggering_mode = 'ON-INSERT') THEN
656: MERGE INTO jty_changed_terrs A
657: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
658: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
659: WHEN MATCHED THEN
660: UPDATE SET
661: A.source_id = S.source_id

Line 685: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S

681: ,'Y'
682: ,'I');
683: ELSIF (triggering_mode = 'ON-DELETE') THEN
684: MERGE INTO jty_changed_terrs A
685: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
686: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
687: WHEN MATCHED THEN
688: UPDATE SET
689: A.source_id = S.source_id