eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 72: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

68: )
69: IS
70:
71: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;
72: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
73:
74: BEGIN
75:
76: IF g_nested_level = 0 THEN -- swtich tracing on/off at the top level only

Line 785: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;

781: ) RETURN VARCHAR2
782: IS
783:
784: -- Variable Declaration
785: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
786: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
787: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
788:
789: l_itr NUMBER(3);

Line 786: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

782: IS
783:
784: -- Variable Declaration
785: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
786: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
787: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
788:
789: l_itr NUMBER(3);
790: l_next_itr NUMBER(3);

Line 787: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

783:
784: -- Variable Declaration
785: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
786: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
787: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
788:
789: l_itr NUMBER(3);
790: l_next_itr NUMBER(3);
791: l_skip_itr NUMBER(3) := NULL;

Line 2357: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2353: ,p_effective_date IN DATE
2354: ) RETURN VARCHAR2
2355: IS
2356:
2357: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2358: l_retval VARCHAR2(1) := 'Y';
2359: l_effective_date DATE;
2360:
2361:

Line 3158: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3154: l_no_of_events NUMBER;
3155:
3156: -- Rowtype Variable Declaration
3157: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
3158: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3159: l_assignment_action_id number;
3160: l_proc_name VARCHAR2(61):=
3161: g_proc_name||'get_events';
3162:

Line 5588: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

5584: IS
5585:
5586: -- Rowtype Variable Declaration
5587: l_sec_asgs csr_eff_sec_assignments%ROWTYPE;
5588: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
5589: l_tab_eff_sec_asgs t_sec_asgs_type;
5590: l_rep_primary_asg VARCHAR2(1);
5591: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
5592:

Line 5591: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

5587: l_sec_asgs csr_eff_sec_assignments%ROWTYPE;
5588: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
5589: l_tab_eff_sec_asgs t_sec_asgs_type;
5590: l_rep_primary_asg VARCHAR2(1);
5591: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
5592:
5593: l_asg_details csr_asg_details_up%ROWTYPE;
5594:
5595: --

Line 5867: from per_all_assignments_f paa

5863:
5864: Cursor csr_get_empcat ( c_assignment_id in number
5865: ,c_effective_date in date ) Is
5866: Select paa.employment_category
5867: from per_all_assignments_f paa
5868: where paa.assignment_id = c_assignment_id
5869: and c_effective_date between paa.effective_start_date
5870: and paa.effective_end_date;
5871: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;

Line 5871: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;

5867: from per_all_assignments_f paa
5868: where paa.assignment_id = c_assignment_id
5869: and c_effective_date between paa.effective_start_date
5870: and paa.effective_end_date;
5871: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;
5872: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;
5873: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;
5874: l_return_value varchar2(7) :=' ';
5875: l_error_value number;

Line 5872: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;

5868: where paa.assignment_id = c_assignment_id
5869: and c_effective_date between paa.effective_start_date
5870: and paa.effective_end_date;
5871: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;
5872: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;
5873: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;
5874: l_return_value varchar2(7) :=' ';
5875: l_error_value number;
5876: l_proc_name varchar2(70):= g_proc_name||'Get_Special_ClassRule';

Line 5873: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;

5869: and c_effective_date between paa.effective_start_date
5870: and paa.effective_end_date;
5871: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;
5872: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;
5873: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;
5874: l_return_value varchar2(7) :=' ';
5875: l_error_value number;
5876: l_proc_name varchar2(70):= g_proc_name||'Get_Special_ClassRule';
5877:

Line 10974: FROM per_all_assignments_f asg

10970:
10971: CURSOR csr_per_details IS
10972: SELECT per.person_id person_id
10973: ,per.national_identifier national_identifier
10974: FROM per_all_assignments_f asg
10975: ,per_all_people_f per
10976: WHERE asg.assignment_id = p_assignment_id
10977: AND per.person_id = asg.person_id;
10978:

Line 12104: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12100: ,p_secondary_assignment_id OUT NOCOPY NUMBER
12101: ) RETURN VARCHAR2
12102: IS
12103:
12104: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12105: l_retval VARCHAR2(1) := 'Y';
12106: l_effective_date DATE;
12107:
12108: l_proc_name varchar2(60) := g_proc_name || 'chk_report_assignment1';

Line 12200: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12196: ,p_report_assignment OUT NOCOPY VARCHAR2
12197: ) RETURN NUMBER
12198: IS
12199:
12200: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12201: l_retval VARCHAR2(1) := 'Y';
12202: l_effective_date DATE;
12203:
12204: l_proc_name varchar2(60) := g_proc_name || 'chk_report_assignment2';

Line 12596: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12592: IS
12593: l_return_value char(7);
12594: l_proc_name VARCHAR2(61):=
12595: g_proc_name||'get_tp1_career_indicator';
12596: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12597: l_report_asg VARCHAR2(1);
12598:
12599: BEGIN -- get_tp1_career_indicator
12600:

Line 12636: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12632: IS
12633: l_return_value char(7);
12634: l_proc_name VARCHAR2(61):=
12635: g_proc_name||'get_tp1_london_allowance';
12636: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12637: l_report_asg VARCHAR2(1);
12638:
12639: BEGIN -- get_tp1_london_allowance
12640:

Line 12687: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12683: IS
12684: l_return_value char(7);
12685: l_proc_name VARCHAR2(61):=
12686: g_proc_name||'get_tp1_sp_allowance';
12687: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12688: l_report_asg VARCHAR2(1);
12689:
12690: BEGIN -- get_tp1_sp_allowance
12691:

Line 12737: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12733: IS
12734: l_return_value char(7);
12735: l_proc_name VARCHAR2(61):=
12736: g_proc_name||'get_tp1_pt_contract_indicator';
12737: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12738: l_report_asg VARCHAR2(1);
12739:
12740: BEGIN -- get_tp1_pt_contract_indicator
12741:

Line 13789: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

13785: PROCEDURE recalc_data_elements
13786: (p_dtl_rec IN OUT NOCOPY csr_rslt_dtl%ROWTYPE
13787: ,p_rec_type IN VARCHAR2
13788: ,p_event_details IN stored_events_type
13789: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
13790: )
13791: IS
13792:
13793: -- Variable Declaration

Line 13819: l_temp_location_id per_all_assignments_f.location_id%TYPE;

13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
13816: l_rowcount NUMBER:=0;
13817: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
13818: l_asg_details csr_asg_details_up%ROWTYPE;
13819: l_temp_location_id per_all_assignments_f.location_id%TYPE;
13820:
13821: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
13822: l_report_primary_asg VARCHAR2(1);
13823:

Line 13821: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

13817: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
13818: l_asg_details csr_asg_details_up%ROWTYPE;
13819: l_temp_location_id per_all_assignments_f.location_id%TYPE;
13820:
13821: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
13822: l_report_primary_asg VARCHAR2(1);
13823:
13824: -- Rowtype Variable Declaration
13825:

Line 15127: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

15123: l_leaver_date DATE := NULL;
15124: l_restarter VARCHAR2(1) := 'N';
15125: l_restarter_date DATE := NULL;
15126: l_continue VARCHAR2(1);
15127: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15128: l_restarter_ext_emp_cat_cd VARCHAR2(1);
15129: l_leaver_ext_emp_cat_cd VARCHAR2(1);
15130:
15131: -- LVRDATE change:

Line 15867: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

15863: --
15864: -- create_new_lines
15865: --
15866: PROCEDURE create_new_lines
15867: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
15868: )
15869: IS
15870:
15871: -- Variable Declaration

Line 16390: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;

16386: ) RETURN VARCHAR2
16387: IS
16388:
16389: -- Variable Declaration
16390: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
16391: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
16392: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
16393:
16394: -- Rowtype Variable Declaration

Line 16391: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

16387: IS
16388:
16389: -- Variable Declaration
16390: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
16391: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
16392: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
16393:
16394: -- Rowtype Variable Declaration
16395: l_all_sec_asgs t_sec_asgs_type;

Line 16392: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

16388:
16389: -- Variable Declaration
16390: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
16391: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
16392: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
16393:
16394: -- Rowtype Variable Declaration
16395: l_all_sec_asgs t_sec_asgs_type;
16396:

Line 16923: FROM per_all_assignments_f

16919: AND effective_end_date;
16920:
16921: CURSOR c_asg_grade IS
16922: SELECT grade_id
16923: FROM per_all_assignments_f
16924: WHERE assignment_id = p_assignment_id
16925: AND p_effective_date BETWEEN effective_start_date
16926: AND effective_end_date;
16927:

Line 17333: FROM per_grades pgr,per_all_assignments_f paaf

17329: ) IS
17330: SELECT decode(c_allowance_type,'LONDON_ALLOWANCE_RULE',information6,
17331: 'SPECIAL_ALLOWANCE_RULE',information7
17332: ) indicator
17333: FROM per_grades pgr,per_all_assignments_f paaf
17334: WHERE paaf.assignment_id = c_assignment_id
17335: AND c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
17336: AND paaf.grade_id = pgr.grade_id
17337: AND pgr.information_category = 'GB_PQP_PENSERV_GRADE_INFO';