DBA Data[Home] [Help]

APPS.PSB_ENTITY_SET_PVT dependencies on PSB_ACCOUNT_POSITION_SETS

Line 712: FROM psb_account_position_sets

708: WHERE entity_set_id = p_source_entity_set_id ;
709: --
710: CURSOR l_find_position_set_id_csr IS
711: SELECT account_position_set_id
712: FROM psb_account_position_sets
713: WHERE name = l_position_set_name
714: and data_extract_id = p_target_data_extract_id ;
715: --
716: CURSOR l_find_attribute_value_id_csr IS

Line 1032: FROM psb_account_position_sets pas,

1028: -- Code to copy sets associated with the parameter.
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,

Line 1787: psb_account_position_sets sets,

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,
1791: psb_attribute_values attr_values