[Home] [Help]
688:
689: --
690: --Get the Zero_fill flag defined for the Account Hierarchy ID
691: --
692: CURSOR cur_hier_accounts (cp_acct_hier_id igs_fi_hier_accounts.acct_hier_id%TYPE)
693: IS
694: SELECT zero_fill_flag
695: FROM igs_fi_hier_accounts
696: WHERE acct_hier_id = cp_acct_hier_id;
691: --
692: CURSOR cur_hier_accounts (cp_acct_hier_id igs_fi_hier_accounts.acct_hier_id%TYPE)
693: IS
694: SELECT zero_fill_flag
695: FROM igs_fi_hier_accounts
696: WHERE acct_hier_id = cp_acct_hier_id;
697:
698: l_hier_accounts_rec cur_hier_accounts%ROWTYPE;
699:
699:
700: --
701: --Get the Account Hierarchy Order Details for Entities Associated with given Account Hierarchy ID
702: --
703: CURSOR cur_hier_acct_tbl (cp_acct_hier_id igs_fi_hier_accounts.acct_hier_id%TYPE)
704: IS
705: SELECT acct_tbl_id,
706: order_sequence,
707: entity_type_code