APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 65: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

61: )
62: IS
63: -- l_trace_options VARCHAR2(200);
64: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;
65: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
66:
67: BEGIN
68:
69: -- --Uncomment this code to run the extract with a debug trace

Line 2153: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2149: l_estb_number VARCHAR2(4);
2150:
2151: l_report_asg VARCHAR2(1) ;
2152: l_tp1_nested_level NUMBER ;
2153: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2154:
2155: BEGIN
2156:
2157: debug_enter(l_proc_name);

Line 2262: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2258: 'get_tp4_employment_category';
2259:
2260: l_report_asg VARCHAR2(1) ;
2261: l_tp1_nested_level NUMBER ;
2262: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2263:
2264: BEGIN
2265:
2266: debug_enter(l_proc_name);

Line 2478: l_value per_all_assignments_f.ass_attribute1%type;

2474:
2475: l_proc_name VARCHAR2(61):=
2476: g_proc_name||'get_formatted_dfee_refno';
2477:
2478: l_value per_all_assignments_f.ass_attribute1%type;
2479: --Keep len same as that of l_dfee_refno
2480: l_num_pos NUMBER := 0;
2481: l_sep_pos NUMBER := -1;
2482: l_sep_count NUMBER := 0;

Line 2580: l_dfee_refno per_all_assignments_f.ass_attribute1%type;

2576: -- Flexfield Name
2577: l_column_name pay_user_column_instances_f.value%type;
2578: -- Flexfield Segment Name
2579:
2580: l_dfee_refno per_all_assignments_f.ass_attribute1%type;
2581: -- Max length based on the highest possible length of all its sources
2582: -- PER_QUALIFICATIONS_V MEMBERSHIP_NUMBER VARCHAR2(80)
2583: -- PER_ALL_PEOPLE_F PER_INFORMATION1 VARCHAR2(150)
2584:

Line 2856: l_assignment_id per_all_assignments_f.assignment_id%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:
2859: -- Added for salary scale changes
2860: