APPS.PAY_FR_ARC_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 1611: l_coefficient_name fnd_id_flex_segments.segment_name%TYPE;

1607: --
1608: l_qualifier fnd_segment_attribute_values.segment_attribute_type%TYPE;
1609: l_cagr_value per_cagr_grades_def.segment1%TYPE;
1610: l_coefficient per_cagr_grades_def.segment1%TYPE;
1611: l_coefficient_name fnd_id_flex_segments.segment_name%TYPE;
1612: --
1613: -- Archiver local variables
1614: --
1615: l_action_info_id number (15);

Line 1739: ,fnd_id_flex_segments seg

1735: ,'SEGMENT20', CAGR.segment20, null),1,60) seg_value
1736: from
1737: per_all_assignments_f asg
1738: ,per_cagr_grades_def cagr
1739: ,fnd_id_flex_segments seg
1740: ,fnd_id_flex_segments_tl seg_tl
1741: ,fnd_segment_attribute_values gqual
1742: where asg.assignment_id = p_assignment_id
1743: and asg.cagr_grade_def_id = CAGR.cagr_grade_def_id (+)

Line 1740: ,fnd_id_flex_segments_tl seg_tl

1736: from
1737: per_all_assignments_f asg
1738: ,per_cagr_grades_def cagr
1739: ,fnd_id_flex_segments seg
1740: ,fnd_id_flex_segments_tl seg_tl
1741: ,fnd_segment_attribute_values gqual
1742: where asg.assignment_id = p_assignment_id
1743: and asg.cagr_grade_def_id = CAGR.cagr_grade_def_id (+)
1744: and gqual.id_flex_num(+) = CAGR.id_flex_num