APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_SET_RELATIONS

Line 558: from PSB_SET_RELATIONS

554: where pay_element_id = elemid;
555:
556: cursor c_setrel (possetgrpid NUMBER) is
557: select *
558: from PSB_SET_RELATIONS
559: where position_set_group_id = possetgrpid;
560:
561: cursor c_posset (possetid NUMBER) is
562: select *

Line 630: select PSB_SET_RELATIONS_S.NEXTVAL seq

626: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq
627: from dual;
628:
629: cursor c_setrel_seq is
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

Line 8836: PSB_SET_RELATIONS c,

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'
8840: and a.chart_of_accounts_id = p_gl_flex_code

Line 12342: from PSB_SET_RELATIONS

12338: l_return_status VARCHAR2(1);
12339: --
12340: cursor c_setrel (possetgrpid NUMBER) is
12341: select *
12342: from PSB_SET_RELATIONS
12343: where position_set_group_id = possetgrpid;
12344:
12345: cursor c_set_rel_exists (possetgrpid NUMBER, pos_set_id NUMBER) is
12346: select set_relation_id

Line 12347: from PSB_SET_RELATIONS

12343: where position_set_group_id = possetgrpid;
12344:
12345: cursor c_set_rel_exists (possetgrpid NUMBER, pos_set_id NUMBER) is
12346: select set_relation_id
12347: from PSB_SET_RELATIONS
12348: where position_set_group_id = possetgrpid
12349: and account_position_set_id = pos_set_id;
12350:
12351: cursor c_posset (possetid NUMBER) is

Line 12368: select PSB_SET_RELATIONS_S.NEXTVAL seq

12364: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq
12365: from dual;
12366:
12367: cursor c_setrel_seq is
12368: select PSB_SET_RELATIONS_S.NEXTVAL seq
12369: from dual;
12370:
12371:
12372: --