eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_PAY_ELEMENTS

Line 518: from PSB_PAY_ELEMENTS

514: Bug No 2579818 End */
515:
516: cursor c_elem is
517: select *
518: from PSB_PAY_ELEMENTS
519: where pay_element_id = p_pay_element_id;
520:
521: cursor c_elemname_exists (elemname VARCHAR2) is
522: select pay_element_id, rowid

Line 523: from PSB_PAY_ELEMENTS

519: where pay_element_id = p_pay_element_id;
520:
521: cursor c_elemname_exists (elemname VARCHAR2) is
522: select pay_element_id, rowid
523: from PSB_PAY_ELEMENTS
524: where name = elemname
525: and data_extract_id = p_target_data_extract_id;
526:
527: cursor c_elemoptions (elemid NUMBER) is

Line 610: select psb_pay_elements_s.nextval seq

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
611: from dual;
612:
613: cursor c_elemoptions_seq is
614: select psb_pay_element_options_s.nextval seq

Line 679: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

675: for c_elem_seq_rec in c_elem_seq loop
676: l_pay_element_id := c_elem_seq_rec.seq;
677: end loop;
678:
679: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
680: (p_api_version => 1.0,
681: p_return_status => l_return_status,
682: p_msg_count => l_msg_count,
683: p_msg_data => l_msg_data,

Line 1374: PSB_PAY_ELEMENTS_PVT.UPDATE_ROW

1370: begin /* Element already exists in the target data extract */
1371:
1372: -- update element definition
1373:
1374: PSB_PAY_ELEMENTS_PVT.UPDATE_ROW
1375: (p_api_version => 1.0,
1376: p_return_status => l_return_status,
1377: p_msg_count => l_msg_count,
1378: p_msg_data => l_msg_data,

Line 1576: from PSB_PAY_ELEMENTS

1572: l_return_status VARCHAR2(1);
1573:
1574: cursor c_elem is
1575: select *
1576: from PSB_PAY_ELEMENTS
1577: where data_extract_id = p_source_data_extract_id;
1578:
1579: cursor c_elemname_exists (elemname VARCHAR2) is
1580: select pay_element_id, rowid

Line 1581: from PSB_PAY_ELEMENTS

1577: where data_extract_id = p_source_data_extract_id;
1578:
1579: cursor c_elemname_exists (elemname VARCHAR2) is
1580: select pay_element_id, rowid
1581: from PSB_PAY_ELEMENTS
1582: where name = elemname
1583: and data_extract_id = p_target_data_extract_id;
1584:
1585: cursor c_elemoptions (elemid NUMBER) is

Line 1621: select psb_pay_elements_s.nextval seq

1617: where b.pay_element_id = a.pay_element_id
1618: and b.worksheet_id = p_worksheet_id)));
1619:
1620: cursor c_elem_seq is
1621: select psb_pay_elements_s.nextval seq
1622: from dual;
1623:
1624: cursor c_elemoptions_seq is
1625: select psb_pay_element_options_s.nextval seq

Line 1650: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

1646: for c_elem_seq_rec in c_elem_seq loop
1647: l_pay_element_id := c_elem_seq_rec.seq;
1648: end loop;
1649:
1650: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
1651: (p_api_version => 1.0,
1652: p_return_status => l_return_status,
1653: p_msg_count => l_msg_count,
1654: p_msg_data => l_msg_data,

Line 1801: PSB_PAY_ELEMENTS_PVT.UPDATE_ROW

1797: begin /* Element already exists in the target data extract */
1798:
1799: -- update element definition
1800:
1801: PSB_PAY_ELEMENTS_PVT.UPDATE_ROW
1802: (p_api_version => 1.0,
1803: p_return_status => l_return_status,
1804: p_msg_count => l_msg_count,
1805: p_msg_data => l_msg_data,

Line 3153: PSB_PAY_ELEMENTS pe

3149: pas.element_value_type,
3150: pas.currency_code,
3151: pas.pay_basis
3152: from PSB_POSITION_ASSIGNMENTS pas,
3153: PSB_PAY_ELEMENTS pe
3154: where pas.position_id = positionid
3155: and pas.assignment_type = 'ELEMENT'
3156: and ((pas.worksheet_id = p_worksheet_id)
3157: or (worksheet_id is null

Line 3167: from PSB_PAY_ELEMENTS a,

3163: and pas.pay_element_id = pe.pay_element_id;
3164:
3165: cursor c_re_elem (elemid NUMBER) is
3166: select a.pay_element_id
3167: from PSB_PAY_ELEMENTS a,
3168: PSB_PAY_ELEMENTS b
3169: where a.name = b.name
3170: and a.data_extract_id = p_target_data_extract_id
3171: and b.pay_element_id = elemid;

Line 3168: PSB_PAY_ELEMENTS b

3164:
3165: cursor c_re_elem (elemid NUMBER) is
3166: select a.pay_element_id
3167: from PSB_PAY_ELEMENTS a,
3168: PSB_PAY_ELEMENTS b
3169: where a.name = b.name
3170: and a.data_extract_id = p_target_data_extract_id
3171: and b.pay_element_id = elemid;
3172:

Line 4206: from PSB_PAY_ELEMENTS a,

4202: group by pay_element_id;
4203:
4204: cursor c_re_elem (elemid NUMBER) is
4205: select a.pay_element_id
4206: from PSB_PAY_ELEMENTS a,
4207: PSB_PAY_ELEMENTS b
4208: where a.name = b.name
4209: and a.data_extract_id = p_target_data_extract_id
4210: and b.pay_element_id = elemid;

Line 4207: PSB_PAY_ELEMENTS b

4203:
4204: cursor c_re_elem (elemid NUMBER) is
4205: select a.pay_element_id
4206: from PSB_PAY_ELEMENTS a,
4207: PSB_PAY_ELEMENTS b
4208: where a.name = b.name
4209: and a.data_extract_id = p_target_data_extract_id
4210: and b.pay_element_id = elemid;
4211:

Line 8168: from PSB_PAY_ELEMENTS a,

8164: l_element_exists BOOLEAN := FALSE;
8165:
8166: cursor c_re_element is
8167: select b.pay_element_id
8168: from PSB_PAY_ELEMENTS a,
8169: PSB_PAY_ELEMENTS b
8170: where a.pay_element_id = p_element_id
8171: and b.data_extract_id = p_data_extract_id
8172: and b.name = a.name;

Line 8169: PSB_PAY_ELEMENTS b

8165:
8166: cursor c_re_element is
8167: select b.pay_element_id
8168: from PSB_PAY_ELEMENTS a,
8169: PSB_PAY_ELEMENTS b
8170: where a.pay_element_id = p_element_id
8171: and b.data_extract_id = p_data_extract_id
8172: and b.name = a.name;
8173:

Line 8487: from psb_pay_elements

8483: l_no_elem_count NUMBER := 0;
8484:
8485: cursor c_no_element_map is
8486: select pay_element_id, name
8487: from psb_pay_elements
8488: where data_extract_id = p_system_data_extract_id
8489: and budget_set_id is null;
8490:
8491: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Budget_Set';

Line 8566: from psb_pay_elements ppe,

8562: l_element_costs elem_costs;
8563:
8564: cursor c_Element_Costs is
8565: select ppe.pay_element_id, ppe.budget_set_id, sum(nvl(ppc.element_cost,0)) element_cost
8566: from psb_pay_elements ppe,
8567: psb_position_costs ppc,
8568: psb_positions pp
8569: where ppe.data_extract_id = p_data_extract_id
8570: and ppc.pay_element_id = ppe.pay_element_id

Line 8655: from PSB_PAY_ELEMENTS c, PSB_POSITION_PAY_DISTRIBUTIONS b

8651:
8652: cursor c_Dist is
8653: select distinct c.pay_element_id, b.code_combination_id,
8654: b.distribution_percent
8655: from PSB_PAY_ELEMENTS c, PSB_POSITION_PAY_DISTRIBUTIONS b
8656: where c.data_extract_id = p_data_extract_id
8657: and c.salary_flag = 'Y'
8658: and b.position_id in
8659: (select a.position_id from PSB_POSITIONS a

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 10219: from psb_pay_elements ppe,

10215:
10216: cursor c_budget_set_cost (startdate DATE, enddate DATE) is
10217: select ppe.budget_set_id hr_budget_set_id,
10218: sum(nvl(ppc.element_cost,0)) budget_set_cost
10219: from psb_pay_elements ppe,
10220: psb_position_costs ppc,
10221: psb_positions pp
10222: where ppe.data_extract_id = p_system_data_extract_id
10223: and pp.hr_position_id = p_hr_position_id