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 2471: l_value per_all_assignments_f.ass_attribute1%type;

2467:
2468: l_proc_name VARCHAR2(61):=
2469: g_proc_name||'get_formatted_dfee_refno';
2470:
2471: l_value per_all_assignments_f.ass_attribute1%type;
2472: --Keep len same as that of l_dfee_refno
2473: l_num_pos NUMBER := 0;
2474: l_sep_pos NUMBER := -1;
2475: l_sep_count NUMBER := 0;

Line 2573: l_dfee_refno per_all_assignments_f.ass_attribute1%type;

2569: -- Flexfield Name
2570: l_column_name pay_user_column_instances_f.value%type;
2571: -- Flexfield Segment Name
2572:
2573: l_dfee_refno per_all_assignments_f.ass_attribute1%type;
2574: -- Max length based on the highest possible length of all its sources
2575: -- PER_QUALIFICATIONS_V MEMBERSHIP_NUMBER VARCHAR2(80)
2576: -- PER_ALL_PEOPLE_F PER_INFORMATION1 VARCHAR2(150)
2577:

Line 2849: l_assignment_id per_all_assignments_f.assignment_id%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:
2852: -- Added for salary scale changes
2853: