APPS.PSB_PAY_ELEMENTS_PVT dependencies on PSB_ELEMENT_POS_SET_GROUPS

Line 485: FROM psb_element_pos_set_groups

481:
482: FOR l_pos_set_group_rec IN
483: (
484: SELECT position_set_group_id
485: FROM psb_element_pos_set_groups
486: WHERE pay_element_id = l_pay_element_id
487: )
488: LOOP
489:

Line 528: FROM psb_element_pos_set_groups

524: DELETE psb_pay_element_distributions
525: WHERE position_set_group_id IN
526: (
527: SELECT position_set_group_id
528: FROM psb_element_pos_set_groups
529: WHERE pay_element_id = l_pay_element_id
530: ) ;
531:
532: DELETE psb_element_pos_set_groups

Line 532: DELETE psb_element_pos_set_groups

528: FROM psb_element_pos_set_groups
529: WHERE pay_element_id = l_pay_element_id
530: ) ;
531:
532: DELETE psb_element_pos_set_groups
533: WHERE pay_element_id = l_pay_element_id ;
534:
535:
536: --

Line 1158: FROM psb_element_pos_set_groups

1154: AND worksheet_id IS NULL;
1155:
1156: CURSOR l_set_groups_csr is
1157: select position_set_group_id,name
1158: FROM psb_element_pos_set_groups
1159: WHERE pay_element_id = p_source_pay_element_id;
1160:
1161: CURSOR l_position_sets_csr is
1162: SELECT aps.name,

Line 1460: SELECT psb_element_pos_set_groups_s.NEXTVAL

1456: For l_set_groups_rec in l_set_groups_csr
1457: Loop
1458: l_source_set_group_id := l_set_groups_rec.position_set_group_id;
1459:
1460: SELECT psb_element_pos_set_groups_s.NEXTVAL
1461: INTO l_position_set_group_id
1462: FROM DUAL;
1463:
1464: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row

Line 1464: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row

1460: SELECT psb_element_pos_set_groups_s.NEXTVAL
1461: INTO l_position_set_group_id
1462: FROM DUAL;
1463:
1464: PSB_ELEMENT_POS_SET_GROUPS_PVT.Insert_Row
1465: ( p_api_version => 1.0,
1466: p_init_msg_list => FND_API.G_FALSE,
1467: p_commit => FND_API.G_FALSE,
1468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,