APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_GRADE_DEFINITIONS

Line 2711: l_segment_value per_grade_definitions.segment1%type := NULL; -- Return value

2707: -- Variable Declarations
2708: c_base_table base_table_ref_csr_typ;
2709:
2710: l_query VARCHAR2(4000); -- Dynamically constructed query
2711: l_segment_value per_grade_definitions.segment1%type := NULL; -- Return value
2712:
2713: l_proc_name VARCHAR2(61):= g_proc_name||'get_flex_segment_value';
2714:
2715: BEGIN

Line 2754: l_segment_col_value per_grade_definitions.segment1%type;

2750: ,p_effective_date IN DATE -- Effective Date
2751: ) RETURN VARCHAR2
2752: IS
2753: -- Variable Declarations
2754: l_segment_col_value per_grade_definitions.segment1%type;
2755: -- Keep len same as l_ret_salary_scale
2756: l_entity_rowid ROWID;
2757:
2758: l_proc_name VARCHAR2(61):= g_proc_name||'get_kflex_value';

Line 2774: (p_entity_name => 'PER_GRADE_DEFINITIONS'

2770: debug('After getting rowid',10);
2771:
2772: l_segment_col_value :=
2773: get_flex_segment_value
2774: (p_entity_name => 'PER_GRADE_DEFINITIONS'
2775: ,p_entity_rowid => l_entity_rowid
2776: ,p_segment_col_name => p_segment_name
2777: );
2778:

Line 2844: l_ret_salary_scale per_grade_definitions.segment1%type;

2840: -- Flexfield Name
2841: l_segment_name pay_user_column_instances_f.value%type;
2842: -- Flexfield Segment Name
2843:
2844: l_ret_salary_scale per_grade_definitions.segment1%type;
2845: -- Salary Scale Return Value
2846: -- Max length based on the highest of all its sources
2847: -- PER_GRADE_DEFINITIONS SEGMENTn VARCHAR2(60)
2848:

Line 2847: -- PER_GRADE_DEFINITIONS SEGMENTn VARCHAR2(60)

2843:
2844: l_ret_salary_scale per_grade_definitions.segment1%type;
2845: -- Salary Scale Return Value
2846: -- Max length based on the highest of all its sources
2847: -- PER_GRADE_DEFINITIONS SEGMENTn VARCHAR2(60)
2848:
2849: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2850: l_report_asg VARCHAR2(1);
2851: