APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_ACCOUNT_POSITION_SETS

Line 446: from PSB_ACCOUNT_POSITION_SETS

442: where position_set_group_id = possetgrpid;
443:
444: cursor c_posset (possetid NUMBER) is
445: select *
446: from PSB_ACCOUNT_POSITION_SETS
447: where account_position_set_id = possetid;
448:
449: cursor c_possetline (possetid NUMBER) is
450: select *

Line 461: from PSB_ACCOUNT_POSITION_SETS

457: where line_sequence_id = lineseqid;
458:
459: cursor c_posset_exists (possetname VARCHAR2) is
460: select account_position_set_id
461: from PSB_ACCOUNT_POSITION_SETS
462: where data_extract_id = g_global_data_extract_id
463: and account_or_position_type = 'P'
464: and name = possetname;
465:

Line 513: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq

509: select psb_pay_element_rates_s.nextval seq
510: from dual;
511:
512: cursor c_posset_seq is
513: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq
514: from dual;
515:
516: cursor c_possetline_seq is
517: select PSB_ACCT_POSITION_SET_LINES_S.NEXTVAL seq