APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_GRADE_DEFINITIONS

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

2714: -- Variable Declarations
2715: c_base_table base_table_ref_csr_typ;
2716:
2717: l_query VARCHAR2(4000); -- Dynamically constructed query
2718: l_segment_value per_grade_definitions.segment1%type := NULL; -- Return value
2719:
2720: l_proc_name VARCHAR2(61):= g_proc_name||'get_flex_segment_value';
2721:
2722: BEGIN

Line 2761: l_segment_col_value per_grade_definitions.segment1%type;

2757: ,p_effective_date IN DATE -- Effective Date
2758: ) RETURN VARCHAR2
2759: IS
2760: -- Variable Declarations
2761: l_segment_col_value per_grade_definitions.segment1%type;
2762: -- Keep len same as l_ret_salary_scale
2763: l_entity_rowid ROWID;
2764:
2765: l_proc_name VARCHAR2(61):= g_proc_name||'get_kflex_value';

Line 2781: (p_entity_name => 'PER_GRADE_DEFINITIONS'

2777: debug('After getting rowid',10);
2778:
2779: l_segment_col_value :=
2780: get_flex_segment_value
2781: (p_entity_name => 'PER_GRADE_DEFINITIONS'
2782: ,p_entity_rowid => l_entity_rowid
2783: ,p_segment_col_name => p_segment_name
2784: );
2785:

Line 2851: l_ret_salary_scale per_grade_definitions.segment1%type;

2847: -- Flexfield Name
2848: l_segment_name pay_user_column_instances_f.value%type;
2849: -- Flexfield Segment Name
2850:
2851: l_ret_salary_scale per_grade_definitions.segment1%type;
2852: -- Salary Scale Return Value
2853: -- Max length based on the highest of all its sources
2854: -- PER_GRADE_DEFINITIONS SEGMENTn VARCHAR2(60)
2855:

Line 2854: -- PER_GRADE_DEFINITIONS SEGMENTn VARCHAR2(60)

2850:
2851: l_ret_salary_scale per_grade_definitions.segment1%type;
2852: -- Salary Scale Return Value
2853: -- Max length based on the highest of all its sources
2854: -- PER_GRADE_DEFINITIONS SEGMENTn VARCHAR2(60)
2855:
2856: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2857: l_report_asg VARCHAR2(1);
2858: