APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_ELEMENT_POS_SET_GROUPS

Line 553: from PSB_ELEMENT_POS_SET_GROUPS

549: and pay_element_id = elemid;
550:
551: cursor c_possetgrp (elemid NUMBER) is
552: select *
553: from PSB_ELEMENT_POS_SET_GROUPS
554: where pay_element_id = elemid;
555:
556: cursor c_setrel (possetgrpid NUMBER) is
557: select *

Line 634: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq

630: select PSB_SET_RELATIONS_S.NEXTVAL seq
631: from dual;
632:
633: cursor c_elempossetgrp_seq is
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

Line 828: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row

824: for c_elempossetgrp_seq_rec in c_elempossetgrp_seq loop
825: l_position_set_group_id := c_elempossetgrp_seq_rec.seq;
826: end loop;
827:
828: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row
829: (p_api_version => 1.0,
830: p_return_status => l_return_status,
831: p_msg_count => l_msg_count,
832: p_msg_data => l_msg_data,

Line 8835: PSB_ELEMENT_POS_SET_GROUPS b,

8831: a.segment29, a.segment30,
8832: a.code_combination_id, a.distribution_percent, e.pay_element_id,
8833: e.follow_salary, /* bug No: 3666828 */ e.name
8834: from PSB_PAY_ELEMENTS e, PSB_PAY_ELEMENT_DISTRIBUTIONS a,
8835: PSB_ELEMENT_POS_SET_GROUPS b,
8836: PSB_SET_RELATIONS c,
8837: PSB_BUDGET_POSITIONS d
8838: where e.data_extract_id = p_data_extract_id
8839: and e.salary_flag <> 'Y'

Line 12234: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq

12230: l_msg_data VARCHAR2(2000);
12231: l_return_status VARCHAR2(1);
12232: --
12233: cursor c_elempossetgrp_seq is
12234: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq
12235: from dual;
12236:
12237: cursor c_possetgrp (elemid NUMBER) is
12238: select * from PSB_ELEMENT_POS_SET_GROUPS

Line 12238: select * from PSB_ELEMENT_POS_SET_GROUPS

12234: select PSB_ELEMENT_POS_SET_GROUPS_S.NEXTVAL seq
12235: from dual;
12236:
12237: cursor c_possetgrp (elemid NUMBER) is
12238: select * from PSB_ELEMENT_POS_SET_GROUPS
12239: where pay_element_id = elemid;
12240:
12241: cursor c_possetgrp_exists (psg_name VARCHAR2) is
12242: select position_set_group_id

Line 12243: from PSB_ELEMENT_POS_SET_GROUPS

12239: where pay_element_id = elemid;
12240:
12241: cursor c_possetgrp_exists (psg_name VARCHAR2) is
12242: select position_set_group_id
12243: from PSB_ELEMENT_POS_SET_GROUPS
12244: where pay_element_id = p_new_pay_element_id
12245: and name = psg_name;
12246: --
12247: BEGIN

Line 12265: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row

12261: for c_elempossetgrp_seq_rec in c_elempossetgrp_seq loop
12262: l_possetgrp_id := c_elempossetgrp_seq_rec.seq;
12263: end loop;
12264:
12265: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row
12266: (p_api_version => 1.0,
12267: p_return_status => l_return_status,
12268: p_msg_count => l_msg_count,
12269: p_msg_data => l_msg_data,