APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on DUAL

Line 2087: FROM dual

2083: LOOP
2084: BEGIN
2085: SELECT 1
2086: INTO v_dim_rule_req_count
2087: FROM dual
2088: WHERE EXISTS ( SELECT 1
2089: FROM fnd_concurrent_programs fcp,
2090: fnd_concurrent_requests fcr,
2091: fem_intg_dim_rules idr,

Line 3262: -- Insert individual dimension members for company

3258: ,p_token2 => 'NUM'
3259: ,p_value2 => v_comp_insert_gt_count);
3260:
3261:
3262: -- Insert individual dimension members for company
3263:
3264: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).table_validated_flag = 'N'
3265: THEN
3266: pv_progress := 'Before insert into fem_companies_b';

Line 3499: -- Insert individual dimension members for cost center

3495: ,p_token2 => 'NUM'
3496: ,p_value2 => v_cc_insert_gt_count);
3497:
3498:
3499: -- Insert individual dimension members for cost center
3500:
3501:
3502: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).table_validated_flag = 'N'
3503: THEN

Line 4010: FROM dual

4006: LOOP
4007: BEGIN
4008: SELECT 1
4009: INTO v_dim_rule_req_count
4010: FROM dual
4011: WHERE EXISTS ( SELECT 1
4012: FROM fnd_concurrent_programs fcp,
4013: fnd_concurrent_requests fcr,
4014: fem_intg_dim_rules idr,