APPS.FEM_PL_INCR_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 867: v_cal_per_end_date fem_cal_periods_attr.date_assign_value%TYPE;

863: v_cal_per_dim_id fem_dimensions_b.dimension_id%TYPE;
864: v_API_return_code NUMBER;
865: v_dim_attr_id fem_dim_attributes_b.attribute_id%TYPE;
866: v_dim_attr_ver_id fem_dim_attr_versions_b.version_id%TYPE;
867: v_cal_per_end_date fem_cal_periods_attr.date_assign_value%TYPE;
868: v_row_count NUMBER;
869: v_dim_name1 fem_dimensions_tl.dimension_name%TYPE;
870: v_attr_name fem_dim_attributes_tl.attribute_name%TYPE;
871:

Line 903: FROM fem_cal_periods_attr

899: END IF;
900:
901: SELECT date_assign_value
902: INTO v_cal_per_end_date
903: FROM fem_cal_periods_attr
904: WHERE attribute_id = v_dim_attr_id
905: AND version_id = v_dim_attr_ver_id
906: AND cal_period_id = p_cal_period_id;
907:

Line 928: -- fem_cal_periods_attr a

924: --
925: -- SELECT count(*)
926: -- INTO v_row_count
927: -- FROM fem_pl_requests r,
928: -- fem_cal_periods_attr a
929: -- WHERE r.ledger_id = p_ledger_id
930: -- AND r.output_dataset_code = p_dataset_code
931: -- AND r.exec_status_code = 'SUCCESS'
932: -- AND a.attribute_id = v_dim_attr_id

Line 947: fem_cal_periods_attr a

943: INTO v_row_count
944: FROM fem_pl_requests r,
945: fem_pl_object_executions e,
946: fem_object_catalog_b o,
947: fem_cal_periods_attr a
948: WHERE r.ledger_id = p_ledger_id
949: AND r.output_dataset_code = p_dataset_code
950: AND r.exec_status_code = 'SUCCESS'
951: AND e.request_id = r.request_id