APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_ACCOUNT_POSITION_SETS

Line 563: from PSB_ACCOUNT_POSITION_SETS

559: where position_set_group_id = possetgrpid;
560:
561: cursor c_posset (possetid NUMBER) is
562: select *
563: from PSB_ACCOUNT_POSITION_SETS
564: where account_position_set_id = possetid;
565:
566: cursor c_possetline (possetid NUMBER) is
567: select *

Line 578: from PSB_ACCOUNT_POSITION_SETS

574: where line_sequence_id = lineseqid;
575:
576: cursor c_posset_exists (possetname VARCHAR2) is
577: select account_position_set_id, rowid
578: from PSB_ACCOUNT_POSITION_SETS
579: where data_extract_id = p_target_data_extract_id
580: and account_or_position_type = 'P'
581: and name = possetname;
582:

Line 618: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq

614: select psb_pay_element_options_s.nextval seq
615: from dual;
616:
617: cursor c_posset_seq is
618: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq
619: from dual;
620:
621: cursor c_possetline_seq is
622: select PSB_ACCT_POSITION_SET_LINES_S.NEXTVAL seq

Line 12353: from PSB_ACCOUNT_POSITION_SETS

12349: and account_position_set_id = pos_set_id;
12350:
12351: cursor c_posset (possetid NUMBER) is
12352: select *
12353: from PSB_ACCOUNT_POSITION_SETS
12354: where account_position_set_id = possetid;
12355:
12356: cursor c_posset_exists (possetname VARCHAR2) is
12357: select account_position_set_id , attribute_selection_type, rowid

Line 12358: from PSB_ACCOUNT_POSITION_SETS

12354: where account_position_set_id = possetid;
12355:
12356: cursor c_posset_exists (possetname VARCHAR2) is
12357: select account_position_set_id , attribute_selection_type, rowid
12358: from PSB_ACCOUNT_POSITION_SETS
12359: where data_extract_id = p_target_data_extract_id
12360: and account_or_position_type = 'P'
12361: and name = possetname;
12362:

Line 12364: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq

12360: and account_or_position_type = 'P'
12361: and name = possetname;
12362:
12363: cursor c_posset_seq is
12364: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq
12365: from dual;
12366:
12367: cursor c_setrel_seq is
12368: select PSB_SET_RELATIONS_S.NEXTVAL seq