APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_POSITION_ASSIGNMENTS

Line 1453: from PSB_POSITION_ASSIGNMENTS

1449: and data_extract_id = g_global_data_extract_id;
1450:
1451: cursor c_posassign_attr (positionid NUMBER) is
1452: select *
1453: from PSB_POSITION_ASSIGNMENTS
1454: where (worksheet_id is null or worksheet_id = p_local_worksheet_id)
1455: and assignment_type = 'ATTRIBUTE'
1456: and position_id = positionid;
1457:

Line 1477: from PSB_POSITION_ASSIGNMENTS

1473: and b.attribute_value_id = attrvalid;
1474:
1475: cursor c_posassign_elem (positionid NUMBER) is
1476: select *
1477: from PSB_POSITION_ASSIGNMENTS
1478: where (worksheet_id is null or worksheet_id = p_local_worksheet_id)
1479: and assignment_type = 'ELEMENT'
1480: and position_id = positionid;
1481:

Line 1501: from PSB_POSITION_ASSIGNMENTS

1497: and nvl(a.sequence_number, -1) = nvl(b.sequence_number, -1);
1498:
1499: cursor c_posassign_emp (positionid NUMBER) is
1500: select *
1501: from PSB_POSITION_ASSIGNMENTS
1502: where (worksheet_id is null or worksheet_id = p_local_worksheet_id)
1503: and assignment_type = 'EMPLOYEE'
1504: and position_id = positionid;
1505:

Line 1525: select PSB_POSITION_ASSIGNMENTS_S.NEXTVAL seq

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
1526: from dual;
1527:
1528: cursor c_posdistr_seq is
1529: select PSB_POSITION_PAY_DISTR_S.NEXTVAL seq

Line 1632: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

1628: for c_posassign_seq_rec in c_posassign_seq loop
1629: l_position_assignment_id := c_posassign_seq_rec.seq;
1630: end loop;
1631:
1632: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
1633: (p_api_version => 1.0,
1634: p_return_status => l_return_status,
1635: p_msg_count => l_msg_count,
1636: p_msg_data => l_msg_data,

Line 1696: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

1692: for c_posassign_seq_rec in c_posassign_seq loop
1693: l_position_assignment_id := c_posassign_seq_rec.seq;
1694: end loop;
1695:
1696: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
1697: (p_api_version => 1.0,
1698: p_return_status => l_return_status,
1699: p_msg_count => l_msg_count,
1700: p_msg_data => l_msg_data,

Line 1748: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row

1744: for c_posassign_seq_rec in c_posassign_seq loop
1745: l_position_assignment_id := c_posassign_seq_rec.seq;
1746: end loop;
1747:
1748: PSB_POSITION_ASSIGNMENTS_PVT.Insert_Row
1749: (p_api_version => 1.0,
1750: p_return_status => l_return_status,
1751: p_msg_count => l_msg_count,
1752: p_msg_data => l_msg_data,