APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_ACCOUNT_POSITION_SET_LINES

Line 568: from PSB_ACCOUNT_POSITION_SET_LINES

564: where account_position_set_id = possetid;
565:
566: cursor c_possetline (possetid NUMBER) is
567: select *
568: from PSB_ACCOUNT_POSITION_SET_LINES
569: where account_position_set_id = possetid;
570:
571: cursor c_possetlineval (lineseqid NUMBER) is
572: select *

Line 600: from PSB_ACCOUNT_POSITION_SET_LINES

596: and b.attribute_value_id = attrvalid;
597:
598: cursor c_possetline_exists (possetid NUMBER, attrid NUMBER) is
599: select line_sequence_id
600: from PSB_ACCOUNT_POSITION_SET_LINES
601: where attribute_id = attrid
602: and account_position_set_id = possetid;
603:
604: cursor c_elemdist (possetgrpid NUMBER) is

Line 12013: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');

12009: Update psb_attribute_values_i
12010: set attribute_id = l_sysorg_id
12011: where attribute_id = p_attribute_id;
12012:
12013: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');
12014: update psb_account_position_set_lines
12015: set attribute_id = l_sysorg_id
12016: where attribute_id = p_attribute_id;
12017:

Line 12014: update psb_account_position_set_lines

12010: set attribute_id = l_sysorg_id
12011: where attribute_id = p_attribute_id;
12012:
12013: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');
12014: update psb_account_position_set_lines
12015: set attribute_id = l_sysorg_id
12016: where attribute_id = p_attribute_id;
12017:
12018: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_PARAMETER_FORMULAS');

Line 12059: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');

12055: Update psb_attribute_values_i
12056: set attribute_id = p_attribute_id
12057: where attribute_id = l_sysorg_id;
12058:
12059: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');
12060: update psb_account_position_set_lines
12061: set attribute_id = p_attribute_id
12062: where attribute_id = l_sysorg_id;
12063:

Line 12060: update psb_account_position_set_lines

12056: set attribute_id = p_attribute_id
12057: where attribute_id = l_sysorg_id;
12058:
12059: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_ACCOUNT_POSITION_SET_LINES');
12060: update psb_account_position_set_lines
12061: set attribute_id = p_attribute_id
12062: where attribute_id = l_sysorg_id;
12063:
12064: FND_FILE.put_line(FND_FILE.LOG, 'Updating Table PSB_PARAMETER_FORMULAS');

Line 12540: from PSB_ACCOUNT_POSITION_SET_LINES

12536: l_return_status VARCHAR2(1);
12537: --
12538: cursor c_possetline (possetid NUMBER) is
12539: select *
12540: from PSB_ACCOUNT_POSITION_SET_LINES
12541: where account_position_set_id = possetid;
12542:
12543: cursor c_possetlineval (lineseqid NUMBER) is
12544: select *

Line 12559: from PSB_ACCOUNT_POSITION_SET_LINES

12555: and b.attribute_value_id = attrvalid;
12556:
12557: cursor c_possetline_exists (possetid NUMBER, attrid NUMBER) is
12558: select line_sequence_id
12559: from PSB_ACCOUNT_POSITION_SET_LINES
12560: where attribute_id = attrid
12561: and account_position_set_id = possetid;
12562:
12563: cursor c_possetlineval_exists (lineseqid NUMBER, attr_val_id NUMBER) is