APPS.JTF_TTY_NA_WF dependencies on DUAL

Line 322: from dual;

318: else
319: -- create a new named account for the party, if one does not exist
320: select JTF_TTY_NAMED_ACCTS_S.nextval
321: into x_account_id
322: from dual;
323: end if;
324:
325: p_site_type_code := get_site_type_code(p_party_id);
326:

Line 356: from dual;

352: );
353:
354: select JTF_TTY_TERR_GRP_ACCTS_S.nextval
355: into p_terr_gp_acct_id
356: from dual;
357:
358: -- assign a named account for the party to terr gp, if one does not exist
359:
360: p_site_type_code := get_site_type_code(p_party_id);

Line 394: from dual;

390: -- assign resource to the named account
391:
392: select jtf_tty_named_acct_rsc_s.nextval
393: into p_terr_gp_acct_rsc_id
394: from dual;
395:
396: insert into jtf_tty_named_acct_rsc
397: (ACCOUNT_RESOURCE_ID,
398: OBJECT_VERSION_NUMBER ,

Line 477: from dual;

473: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('p_account_count = 1: Update mapping rules');
474: -- Update mapping rules for this existing named account by adding the postal code mapping
475: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
476: into l_acct_qual_map_id
477: from dual;
478:
479: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS
480: (account_qual_map_id,
481: object_version_number,

Line 525: FROM DUAL

521: begin
522:
523: SELECT 'Y'
524: INTO l_chk_done
525: FROM DUAL
526: WHERE EXISTS ( select 'Y'
527: from hz_relationships hzr
528: where hzr.subject_table_name = 'HZ_PARTIES'
529: and hzr.object_table_name = 'HZ_PARTIES'

Line 550: FROM DUAL

546:
547: begin
548: SELECT 'Y'
549: INTO l_chk_done
550: FROM DUAL
551: WHERE EXISTS ( select 'Y'
552: from hz_relationships hzr
553: where hzr.subject_table_name = 'HZ_PARTIES'
554: and hzr.object_table_name = 'HZ_PARTIES'

Line 624: from dual;

620: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin create_mapping_rules');
621:
622: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
623: into l_acct_qual_map_id
624: from dual;
625:
626: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS
627: (account_qual_map_id,
628: object_version_number,

Line 654: from dual;

650: , sysdate );
651:
652: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
653: into l_acct_qual_map_id
654: from dual;
655:
656: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS
657: (account_qual_map_id,
658: object_version_number,