APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_POSITION_SET_LINE_VALUES

Line 573: from PSB_POSITION_SET_LINE_VALUES

569: where account_position_set_id = possetid;
570:
571: cursor c_possetlineval (lineseqid NUMBER) is
572: select *
573: from PSB_POSITION_SET_LINE_VALUES
574: where line_sequence_id = lineseqid;
575:
576: cursor c_posset_exists (possetname VARCHAR2) is
577: select account_position_set_id, rowid

Line 585: from PSB_POSITION_SET_LINE_VALUES

581: and name = possetname;
582:
583: cursor c_possetlineval_exists (lineseqid NUMBER, attrval VARCHAR2) is
584: select value_sequence_id
585: from PSB_POSITION_SET_LINE_VALUES
586: where attribute_value = attrval
587: and line_sequence_id = lineseqid;
588:
589: cursor c_re_attrval (attrvalid NUMBER) is

Line 626: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq

622: select PSB_ACCT_POSITION_SET_LINES_S.NEXTVAL seq
623: from dual;
624:
625: cursor c_possetlineval_seq is
626: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq
627: from dual;
628:
629: cursor c_setrel_seq is
630: select PSB_SET_RELATIONS_S.NEXTVAL seq

Line 12545: from PSB_POSITION_SET_LINE_VALUES

12541: where account_position_set_id = possetid;
12542:
12543: cursor c_possetlineval (lineseqid NUMBER) is
12544: select *
12545: from PSB_POSITION_SET_LINE_VALUES
12546: where line_sequence_id = lineseqid;
12547:
12548: cursor c_re_attrval (attrvalid NUMBER) is
12549: select a.attribute_value_id

Line 12570: PSB_POSITION_SET_LINE_VALUES b

12566: where attribute_value_id = attr_val_id
12567: and attribute_value in
12568: (select a.attribute_value
12569: from PSB_ATTRIBUTE_VALUES a,
12570: PSB_POSITION_SET_LINE_VALUES b
12571: where a.attribute_value_id = b.attribute_value_id
12572: and b.line_sequence_id = lineseqid);
12573:
12574: cursor c_possetline_seq is

Line 12579: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq

12575: select PSB_ACCT_POSITION_SET_LINES_S.NEXTVAL seq
12576: from dual;
12577:
12578: cursor c_possetlineval_seq is
12579: select PSB_POSITION_SET_LINE_VALUES_S.NEXTVAL seq
12580: from dual;
12581: --
12582: BEGIN
12583: --