APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_ELEMENT_POS_SET_GROUPS

Line 436: from PSB_ELEMENT_POS_SET_GROUPS

432: and pay_element_id = elemid;
433:
434: cursor c_possetgrp (elemid NUMBER) is
435: select *
436: from PSB_ELEMENT_POS_SET_GROUPS
437: where pay_element_id = elemid;
438:
439: cursor c_setrel (possetgrpid NUMBER) is
440: select *

Line 529: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq

525: select PSB_SET_RELATIONS_S.NEXTVAL seq
526: from dual;
527:
528: cursor c_elempossetgrp_seq is
529: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq
530: from dual;
531:
532: cursor c_elemdist_seq is
533: select PSB_PAY_ELEMENT_DISTRIBUTION_S.NEXTVAL seq

Line 738: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row

734: for c_elempossetgrp_seq_rec in c_elempossetgrp_seq loop
735: l_position_set_group_id := c_elempossetgrp_seq_rec.seq;
736: end loop;
737:
738: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row
739: (p_api_version => 1.0,
740: p_return_status => l_return_status,
741: p_msg_count => l_msg_count,
742: p_msg_data => l_msg_data,