DBA Data[Home] [Help]

APPS.JTF_TTY_NA_WF dependencies on JTF_TTY_ACCT_QUAL_MAPS_S

Line 475: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval

471: elsif (p_account_count = 1)
472: then
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

Line 622: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval

618: l_acct_qual_map_id number;
619: BEGIN
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

Line 652: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval

648: , sysdate
649: , G_USER
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