APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_PAY_ELEMENT_DISTRIBUTIONS

Line 606: from PSB_PAY_ELEMENT_DISTRIBUTIONS

602: and account_position_set_id = possetid;
603:
604: cursor c_elemdist (possetgrpid NUMBER) is
605: select *
606: from PSB_PAY_ELEMENT_DISTRIBUTIONS
607: where position_set_group_id = possetgrpid;
608:
609: cursor c_elem_seq is
610: select psb_pay_elements_s.nextval seq

Line 8834: from PSB_PAY_ELEMENTS e, PSB_PAY_ELEMENT_DISTRIBUTIONS a,

8830: a.segment25, a.segment26, a.segment27, a.segment28,
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

Line 12769: from PSB_PAY_ELEMENT_DISTRIBUTIONS

12765: l_distribution_percent NUMBER;
12766: --
12767: cursor c_elemdist (possetgrpid NUMBER) is
12768: select *
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

Line 12778: from PSB_PAY_ELEMENT_DISTRIBUTIONS

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
12778: from PSB_PAY_ELEMENT_DISTRIBUTIONS
12779: where position_set_group_id = psg_id
12780: and ((cc_id is not null and code_combination_id = cc_id) or (concatenated_segments = con_segments));
12781: --
12782: BEGIN