634: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq
635: from dual;
636:
637: cursor c_elemdist_seq is
638: select PSB_PAY_ELEMENT_DISTRIBUTION_S.NEXTVAL seq
639: from dual;
640:
641: BEGIN
642:
12769: from PSB_PAY_ELEMENT_DISTRIBUTIONS
12770: where position_set_group_id = possetgrpid;
12771:
12772: cursor c_elemdist_seq is
12773: select PSB_PAY_ELEMENT_DISTRIBUTION_S.NEXTVAL seq
12774: from dual;
12775:
12776: cursor c_elemdist_exists (psg_id NUMBER, cc_id NUMBER, con_segments VARCHAR2) is
12777: select distribution_id, distribution_percent