DBA Data[Home] [Help]

APPS.PSB_ENTITY_SET_PVT dependencies on PSB_SET_RELATIONS

Line 1033: psb_set_relations psr

1029: FOR l_sets_rec IN
1030: (
1031: SELECT pas.name, pas.account_or_position_type, psr.*
1032: FROM psb_account_position_sets pas,
1033: psb_set_relations psr
1034: WHERE DECODE(p_entity_type,
1035: 'P', psr.parameter_id,
1036: 'C', psr.constraint_id,
1037: /* Budget Revision Rules Enhancement Start */

Line 1106: SELECT psb_set_relations_s.nextval INTO l_set_relation_id

1102: IF l_sets_rec.account_or_position_type = 'A' OR
1103: l_account_position_set_id IS NOT NULL
1104: THEN
1105:
1106: SELECT psb_set_relations_s.nextval INTO l_set_relation_id
1107: FROM dual;
1108:
1109: IF p_entity_type = 'P' THEN
1110: l_parameter_id := l_entity_id;

Line 1786: psb_set_relations rels,

1782: (
1783: SELECT DISTINCT lines.attribute_id, attr_values.attribute_value
1784: FROM psb_entity_assignment assgn,
1785: psb_entity entity,
1786: psb_set_relations rels,
1787: psb_account_position_sets sets,
1788: psb_account_position_set_lines lines,
1789: psb_position_set_line_values pos_val,
1790: psb_attributes attrs,