APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_POSITIONS

Line 1441: from PSB_POSITIONS

1437: l_return_status VARCHAR2(1);
1438:
1439: cursor c_positions is
1440: select *
1441: from PSB_POSITIONS
1442: where data_extract_id = p_local_data_extract_id;
1443:
1444: cursor c_position_exists (posname VARCHAR2, hrposid NUMBER, hrempid NUMBER) is
1445: select position_id

Line 1446: from PSB_POSITIONS

1442: where data_extract_id = p_local_data_extract_id;
1443:
1444: cursor c_position_exists (posname VARCHAR2, hrposid NUMBER, hrempid NUMBER) is
1445: select position_id
1446: from PSB_POSITIONS
1447: where ((hrposid is null and (hrempid is null or hr_employee_id = hrempid) and name = posname)
1448: or ((hr_position_id = hrposid) and (hrempid is null or hr_employee_id = hrempid)))
1449: and data_extract_id = g_global_data_extract_id;
1450:

Line 1521: select PSB_POSITIONS_S.NEXTVAL seq

1517: where position_id = positionid
1518: and (worksheet_id is null or worksheet_id = p_local_worksheet_id);
1519:
1520: cursor c_pos_seq is
1521: select PSB_POSITIONS_S.NEXTVAL seq
1522: from dual;
1523:
1524: cursor c_posassign_seq is
1525: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq

Line 1553: PSB_POSITIONS_PVT.Insert_Row

1549: for c_pos_seq_rec in c_pos_seq loop
1550: l_position_id := c_pos_seq_rec.seq;
1551: end loop;
1552:
1553: PSB_POSITIONS_PVT.Insert_Row
1554: (p_api_version => 1.0,
1555: p_return_status => l_return_status,
1556: p_msg_count => l_msg_count,
1557: p_msg_data => l_msg_data,

Line 2000: from PSB_POSITIONS a,

1996: and b.pay_element_id = elemid;
1997:
1998: cursor c_re_pos (posid NUMBER) is
1999: select a.position_id
2000: from PSB_POSITIONS a,
2001: PSB_POSITIONS b
2002: where (b.hr_employee_id is null or a.hr_employee_id = b.hr_employee_id)
2003: and a.name = b.name
2004: and a.data_extract_id = g_global_data_extract_id

Line 2001: PSB_POSITIONS b

1997:
1998: cursor c_re_pos (posid NUMBER) is
1999: select a.position_id
2000: from PSB_POSITIONS a,
2001: PSB_POSITIONS b
2002: where (b.hr_employee_id is null or a.hr_employee_id = b.hr_employee_id)
2003: and a.name = b.name
2004: and a.data_extract_id = g_global_data_extract_id
2005: and b.position_id = posid;