DBA Data[Home] [Help]

APPS.PSB_VALIDATE_ACCT_PVT dependencies on FND_ID_FLEX_STRUCTURES

Line 814: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;

810: FUNCTION Get_Active_Segments( p_chart_of_accounts_id IN NUMBER )
811: RETURN BOOLEAN
812: IS
813: /* Start bug #4924031 */
814: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
815: l_application_id fnd_id_flex_structures.application_id%TYPE;
816: l_yes_flag VARCHAR2(1);
817: /* End bug #4924031 */
818:

Line 815: l_application_id fnd_id_flex_structures.application_id%TYPE;

811: RETURN BOOLEAN
812: IS
813: /* Start bug #4924031 */
814: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
815: l_application_id fnd_id_flex_structures.application_id%TYPE;
816: l_yes_flag VARCHAR2(1);
817: /* End bug #4924031 */
818:
819: BEGIN

Line 835: FROM fnd_id_flex_structures str, fnd_id_flex_segments seg

831:
832: FOR l_flex_rec IN
833: (
834: SELECT seg.application_column_name
835: FROM fnd_id_flex_structures str, fnd_id_flex_segments seg
836: WHERE str.application_id = l_application_id -- bug #4924031
837: AND str.id_flex_code = l_id_flex_code -- bug #4924031
838: AND str.id_flex_num = p_chart_of_accounts_id
839: AND str.id_flex_code = seg.id_flex_code