DBA Data[Home] [Help]

APPS.PSB_ENTITY_SET_PVT dependencies on PSB_ENTITY_ASSIGNMENT

Line 897: FROM psb_entity pe, psb_entity_assignment pea

893: pe.effective_start_date start_date, pe.effective_end_date end_date,
894: pea.priority,
895: pea.severity_level, pea.effective_start_date,
896: pea.effective_end_date
897: FROM psb_entity pe, psb_entity_assignment pea
898: WHERE pea.entity_set_id = p_source_entity_set_id
899: and pea.entity_id = pe.entity_id
900: )
901: LOOP

Line 991: PSB_ENTITY_ASSIGNMENT_PVT.INSERT_ROW

987:
988: -- creating assignment between the copied parameter set and the
989: -- copied parameters
990:
991: PSB_ENTITY_ASSIGNMENT_PVT.INSERT_ROW
992: (
993: p_api_version => 1.0,
994: p_init_msg_list => null,
995: p_commit => null,

Line 1784: FROM psb_entity_assignment assgn,

1780:
1781: CURSOR l_attr_value_csr IS
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,

Line 1810: FROM psb_entity_assignment assgn,

1806: )
1807: UNION
1808: (
1809: SELECT DISTINCT formulas.attribute_id, attr_values.attribute_value
1810: FROM psb_entity_assignment assgn,
1811: psb_entity entity,
1812: psb_parameter_formulas formulas,
1813: psb_attributes attrs,
1814: psb_attribute_values attr_values