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 71: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

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

Line 784: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;

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

Line 785: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

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

Line 786: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

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

Line 2385: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2381: ,p_effective_date IN DATE
2382: ) RETURN VARCHAR2
2383: IS
2384:
2385: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2386: l_retval VARCHAR2(1) := 'Y';
2387: l_effective_date DATE;
2388:
2389:

Line 3186: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3182: l_no_of_events NUMBER;
3183:
3184: -- Rowtype Variable Declaration
3185: l_event_group_details pqp_gb_tp_pension_extracts.csr_event_group_details%ROWTYPE;
3186: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3187: l_assignment_action_id number;
3188: l_proc_name VARCHAR2(61):=
3189: g_proc_name||'get_events';
3190:

Line 5616: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

5612: IS
5613:
5614: -- Rowtype Variable Declaration
5615: l_sec_asgs csr_eff_sec_assignments%ROWTYPE;
5616: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
5617: l_tab_eff_sec_asgs t_sec_asgs_type;
5618: l_rep_primary_asg VARCHAR2(1);
5619: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
5620:

Line 5619: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

5615: l_sec_asgs csr_eff_sec_assignments%ROWTYPE;
5616: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
5617: l_tab_eff_sec_asgs t_sec_asgs_type;
5618: l_rep_primary_asg VARCHAR2(1);
5619: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
5620:
5621: l_asg_details csr_asg_details_up%ROWTYPE;
5622:
5623: --

Line 5895: from per_all_assignments_f paa

5891:
5892: Cursor csr_get_empcat ( c_assignment_id in number
5893: ,c_effective_date in date ) Is
5894: Select paa.employment_category
5895: from per_all_assignments_f paa
5896: where paa.assignment_id = c_assignment_id
5897: and c_effective_date between paa.effective_start_date
5898: and paa.effective_end_date;
5899: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;

Line 5899: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;

5895: from per_all_assignments_f paa
5896: where paa.assignment_id = c_assignment_id
5897: and c_effective_date between paa.effective_start_date
5898: and paa.effective_end_date;
5899: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;
5900: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;
5901: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;
5902: l_return_value varchar2(7) :=' ';
5903: l_error_value number;

Line 5900: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;

5896: where paa.assignment_id = c_assignment_id
5897: and c_effective_date between paa.effective_start_date
5898: and paa.effective_end_date;
5899: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;
5900: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;
5901: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;
5902: l_return_value varchar2(7) :=' ';
5903: l_error_value number;
5904: l_proc_name varchar2(70):= g_proc_name||'Get_Special_ClassRule';

Line 5901: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;

5897: and c_effective_date between paa.effective_start_date
5898: and paa.effective_end_date;
5899: l_assig_emp_catcode per_all_assignments_f.employment_category%TYPE;
5900: l_pension_ext_empcode per_all_assignments_f.employment_category%TYPE;
5901: l_pension_ext_wrkpat per_all_assignments_f.employment_category%TYPE;
5902: l_return_value varchar2(7) :=' ';
5903: l_error_value number;
5904: l_proc_name varchar2(70):= g_proc_name||'Get_Special_ClassRule';
5905:

Line 11171: FROM per_all_assignments_f asg

11167:
11168: CURSOR csr_per_details IS
11169: SELECT per.person_id person_id
11170: ,per.national_identifier national_identifier
11171: FROM per_all_assignments_f asg
11172: ,per_all_people_f per
11173: WHERE asg.assignment_id = p_assignment_id
11174: AND per.person_id = asg.person_id;
11175:

Line 12302: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12298: ,p_secondary_assignment_id OUT NOCOPY NUMBER
12299: ) RETURN VARCHAR2
12300: IS
12301:
12302: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12303: l_retval VARCHAR2(1) := 'Y';
12304: l_effective_date DATE;
12305:
12306: l_proc_name varchar2(60) := g_proc_name || 'chk_report_assignment1';

Line 12398: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12394: ,p_report_assignment OUT NOCOPY VARCHAR2
12395: ) RETURN NUMBER
12396: IS
12397:
12398: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12399: l_retval VARCHAR2(1) := 'Y';
12400: l_effective_date DATE;
12401:
12402: l_proc_name varchar2(60) := g_proc_name || 'chk_report_assignment2';

Line 12795: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12791: IS
12792: l_return_value char(7);
12793: l_proc_name VARCHAR2(61):=
12794: g_proc_name||'get_tp1_career_indicator';
12795: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12796: l_report_asg VARCHAR2(1);
12797:
12798: BEGIN -- get_tp1_career_indicator
12799:

Line 12835: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12831: IS
12832: l_return_value char(7);
12833: l_proc_name VARCHAR2(61):=
12834: g_proc_name||'get_tp1_london_allowance';
12835: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12836: l_report_asg VARCHAR2(1);
12837:
12838: BEGIN -- get_tp1_london_allowance
12839:

Line 12886: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12882: IS
12883: l_return_value char(7);
12884: l_proc_name VARCHAR2(61):=
12885: g_proc_name||'get_tp1_sp_allowance';
12886: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12887: l_report_asg VARCHAR2(1);
12888:
12889: BEGIN -- get_tp1_sp_allowance
12890:

Line 12936: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

12932: IS
12933: l_return_value char(7);
12934: l_proc_name VARCHAR2(61):=
12935: g_proc_name||'get_tp1_pt_contract_indicator';
12936: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12937: l_report_asg VARCHAR2(1);
12938:
12939: BEGIN -- get_tp1_pt_contract_indicator
12940:

Line 13988: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

13984: PROCEDURE recalc_data_elements
13985: (p_dtl_rec IN OUT NOCOPY csr_rslt_dtl%ROWTYPE
13986: ,p_rec_type IN VARCHAR2
13987: ,p_event_details IN stored_events_type
13988: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
13989: )
13990: IS
13991:
13992: -- Variable Declaration

Line 14018: l_temp_location_id per_all_assignments_f.location_id%TYPE;

14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
14015: l_rowcount NUMBER:=0;
14016: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
14017: l_asg_details csr_asg_details_up%ROWTYPE;
14018: l_temp_location_id per_all_assignments_f.location_id%TYPE;
14019:
14020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
14021: l_report_primary_asg VARCHAR2(1);
14022:

Line 14020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

14016: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
14017: l_asg_details csr_asg_details_up%ROWTYPE;
14018: l_temp_location_id per_all_assignments_f.location_id%TYPE;
14019:
14020: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
14021: l_report_primary_asg VARCHAR2(1);
14022:
14023: -- Rowtype Variable Declaration
14024:

Line 15326: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

15322: l_leaver_date DATE := NULL;
15323: l_restarter VARCHAR2(1) := 'N';
15324: l_restarter_date DATE := NULL;
15325: l_continue VARCHAR2(1);
15326: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
15327: l_restarter_ext_emp_cat_cd VARCHAR2(1);
15328: l_leaver_ext_emp_cat_cd VARCHAR2(1);
15329:
15330: -- LVRDATE change:

Line 16151: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

16147: --
16148: -- create_new_lines
16149: --
16150: PROCEDURE create_new_lines
16151: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
16152: )
16153: IS
16154:
16155: -- Variable Declaration

Line 16759: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;

16755: ) RETURN VARCHAR2
16756: IS
16757:
16758: -- Variable Declaration
16759: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
16760: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
16761: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
16762:
16763: -- Rowtype Variable Declaration

Line 16760: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;

16756: IS
16757:
16758: -- Variable Declaration
16759: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
16760: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
16761: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
16762:
16763: -- Rowtype Variable Declaration
16764: l_all_sec_asgs t_sec_asgs_type;

Line 16761: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;

16757:
16758: -- Variable Declaration
16759: l_curr_asg_id per_all_assignments_f.assignment_id%TYPE;
16760: l_prev_asg_id per_all_assignments_f.assignment_id%TYPE;
16761: l_sec_asg_id per_all_assignments_f.assignment_id%TYPE;
16762:
16763: -- Rowtype Variable Declaration
16764: l_all_sec_asgs t_sec_asgs_type;
16765:

Line 17292: FROM per_all_assignments_f

17288: AND effective_end_date;
17289:
17290: CURSOR c_asg_grade IS
17291: SELECT grade_id
17292: FROM per_all_assignments_f
17293: WHERE assignment_id = p_assignment_id
17294: AND p_effective_date BETWEEN effective_start_date
17295: AND effective_end_date;
17296:

Line 17702: FROM per_grades pgr,per_all_assignments_f paaf

17698: ) IS
17699: SELECT decode(c_allowance_type,'LONDON_ALLOWANCE_RULE',information6,
17700: 'SPECIAL_ALLOWANCE_RULE',information7
17701: ) indicator
17702: FROM per_grades pgr,per_all_assignments_f paaf
17703: WHERE paaf.assignment_id = c_assignment_id
17704: AND c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
17705: AND paaf.grade_id = pgr.grade_id
17706: AND pgr.information_category = 'GB_PQP_PENSERV_GRADE_INFO';