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 41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;

37: g_oth_rate_type pay_user_column_instances_f.value%type;
38: g_sal_rate_type pay_user_column_instances_f.value%type;
39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;
45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;

Line 42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;

38: g_sal_rate_type pay_user_column_instances_f.value%type;
39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;
45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;
46: g_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;

39: g_sf_rate_type pay_user_column_instances_f.value%type;
40: g_lon_rate_type pay_user_column_instances_f.value%type;
41: g_asg_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;
45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;
46: g_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
47: g_equal_sal_rate VARCHAR2(1);

Line 46: g_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;

42: g_ext_emp_cat_cd per_all_assignments_f.employment_category%TYPE;
43: g_ext_emp_wrkp_cd per_all_assignments_f.employment_category%TYPE;
44: -- g_abs_bal_type_id pay_balance_types.balance_type_id%type;
45: -- g_sal_bal_type_id pay_balance_types.balance_type_id%type;
46: g_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
47: g_equal_sal_rate VARCHAR2(1);
48: -- Added for bugfix 3073562:GAP1:GAP2
49: g_multiperson_mode VARCHAR2(1) := 'N';
50:

Line 61: g_override_ft_asg_id per_all_assignments_f.assignment_id%TYPE;

57: -- Added for bugfix 3803760:TERMASG
58: g_asg_count NUMBER;
59:
60: -- Added for bugfix 3803760:FTSUPPLY
61: g_override_ft_asg_id per_all_assignments_f.assignment_id%TYPE;
62:
63: --added for raising warning for FT asg.
64: g_person_count NUMBER := 0;
65:

Line 135: ,assignment_id per_all_assignments_f.assignment_id%TYPE

131: -- Added new column new_est_number
132: TYPE stored_events_type IS RECORD
133: (event_date DATE
134: ,event_type VARCHAR2(24000)
135: ,assignment_id per_all_assignments_f.assignment_id%TYPE
136: ,new_ext_emp_cat_cd ben_ext_rslt_dtl.val_01%TYPE
137: -- Bugfix 3470242:BUG1 : Now storing location_id as estb_number can
138: -- always be sought using location id
139: -- ,new_estb_number ben_ext_rslt_dtl.val_01%TYPE

Line 140: ,new_location_id per_all_assignments_f.location_id%TYPE

136: ,new_ext_emp_cat_cd ben_ext_rslt_dtl.val_01%TYPE
137: -- Bugfix 3470242:BUG1 : Now storing location_id as estb_number can
138: -- always be sought using location id
139: -- ,new_estb_number ben_ext_rslt_dtl.val_01%TYPE
140: ,new_location_id per_all_assignments_f.location_id%TYPE
141: ,pt_asg_count_change NUMBER
142: -- Added for bugfix 3803760:TERMASG
143: ,asg_count_change NUMBER
144: );

Line 155: ,assignment_id per_all_assignments_f.assignment_id%TYPE

151: TYPE leaver_dates_type IS RECORD
152: (start_date DATE
153: ,leaver_date DATE
154: ,restarter_date DATE
155: ,assignment_id per_all_assignments_f.assignment_id%TYPE
156: );
157:
158: TYPE t_leaver_dates_type IS TABLE OF leaver_dates_type
159: INDEX BY BINARY_INTEGER;

Line 167: ( assignment_id per_all_assignments_f.assignment_id%TYPE

163: -- this table of records will be used in recalc_data_elements to store
164: -- details corresponding of assignment IDs. Instead of calling parttime and FT
165: -- salary function multiple times, this data collection will be used
166: TYPE asg_recalc_details IS RECORD
167: ( assignment_id per_all_assignments_f.assignment_id%TYPE
168: , eff_start_date DATE
169: , eff_end_date DATE
170: , effective_status VARCHAR2(1)
171: , part_time_sal_paid NUMBER

Line 257: TYPE t_leaver_asgs_type IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;

253: )
254: )
255: ORDER BY eaat.effective_start_date; -- effective first
256: */
257: TYPE t_leaver_asgs_type IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;
258:
259: --
260: -- Secondary Assignments which are Effective and future
261: --

Line 273: FROM per_all_assignments_f asg, per_assignment_status_types pss

269: ,asg.business_group_id business_group_id
270: ,DECODE(asg.business_group_id
271: ,g_business_group_id, 0
272: ,asg.business_group_id) bizgrpcol
273: FROM per_all_assignments_f asg, per_assignment_status_types pss
274: WHERE asg.person_id = p_person_id
275: AND asg.assignment_id <> p_primary_assignment_id
276: AND asg.assignment_type = 'E' --only employee assignments
277: AND pss.assignment_status_type_id = asg.assignment_status_type_id

Line 297: FROM per_all_people_f per, per_all_assignments_f asg

293: ,asg.business_group_id business_group_id
294: ,DECODE(asg.business_group_id
295: ,g_business_group_id, 0
296: ,asg.business_group_id) bizgrpcol
297: FROM per_all_people_f per, per_all_assignments_f asg
298: ,per_assignment_status_types pss
299: WHERE per.person_id <> p_person_id
300: AND ((p_effective_date BETWEEN per.effective_start_date
301: AND per.effective_end_date)

Line 370: FROM per_all_assignments_f asg

366: ,asg.business_group_id business_group_id
367: ,DECODE(asg.business_group_id
368: ,g_business_group_id, 0
369: ,asg.business_group_id) bizgrpcol
370: FROM per_all_assignments_f asg
371: WHERE asg.person_id = p_person_id
372: AND asg.assignment_id <> p_primary_assignment_id
373: AND p_effective_date BETWEEN asg.effective_start_date
374: AND asg.effective_end_date

Line 382: FROM per_all_people_f per, per_all_assignments_f asg

378: ,asg.business_group_id business_group_id
379: ,DECODE(asg.business_group_id
380: ,g_business_group_id, 0
381: ,asg.business_group_id) bizgrpcol
382: FROM per_all_people_f per, per_all_assignments_f asg
383: WHERE per.person_id <> p_person_id
384: AND p_effective_date BETWEEN per.effective_start_date
385: AND per.effective_end_date
386: AND g_cross_per_enabled = 'Y' -- Cross Person is enabled

Line 409: FROM per_all_assignments_f asg

405:
406: /* SELECT DISTINCT asg.assignment_id assignment_id
407: -- ,asg.effective_start_date start_date
408: -- ,asg.effective_end_date effective_end_date
409: FROM per_all_assignments_f asg
410: WHERE asg.person_id = p_person_id
411: AND asg.assignment_id <> p_primary_assignment_id
412: AND ( ( nvl(p_effective_date,g_pension_year_start_date)
413: BETWEEN asg.effective_start_date

Line 466: FROM per_all_assignments_f asg

462: ,asg.assignment_id secondary_assignment_id
463: ,asg.effective_start_date teacher_start_date
464: -- added for compatibility with tp4. csr_asg_details.
465: ,0 tp_sf_spinal_point_id
466: FROM per_all_assignments_f asg
467:
468: WHERE asg.assignment_id = p_assignment_id
469: AND ( ( nvl(p_effective_date,g_pension_year_start_date)
470: BETWEEN asg.effective_start_date

Line 511: FROM per_all_assignments_f asg

507: ,asg.assignment_id secondary_assignment_id
508: ,asg.effective_start_date teacher_start_date
509: -- added for compatibility with tp4. csrasg_details.
510: ,0 tp_sf_spinal_point_id
511: FROM per_all_assignments_f asg
512: WHERE asg.assignment_id = p_assignment_id
513: AND ( ( nvl(p_effective_date,g_pension_year_start_date)
514: BETWEEN asg.effective_start_date
515: AND asg.effective_end_date )

Line 624: FROM per_all_people_f per, per_all_assignments_f asg

620: ,per.national_identifier
621: ,per.business_group_id
622: ,asg.assignment_id assignment_id
623: ,NVL(asg.employment_category,'FT') asg_emp_cat_cd
624: FROM per_all_people_f per, per_all_assignments_f asg
625: WHERE per.person_id = p_person_id
626: AND asg.assignment_id <> p_assignment_id
627: AND asg.assignment_type ='E'
628: --AND p_effective_date BETWEEN per.effective_start_date

Line 662: FROM per_all_people_f per, per_all_assignments_f asg

658: ,per.national_identifier
659: ,per.business_group_id
660: ,asg.assignment_id assignment_id
661: ,NVL(asg.employment_category,'FT') asg_emp_cat_cd
662: FROM per_all_people_f per, per_all_assignments_f asg
663: WHERE per.person_id <> p_person_id
664: -- AND p_effective_date BETWEEN per.effective_start_date
665: -- AND per.effective_end_date
666: AND (

Line 1337: ,per_all_assignments_f paaf

1333: )
1334: IS
1335: SELECT max(ptp.end_date) previous_payroll_date
1336: FROM per_time_periods ptp
1337: ,per_all_assignments_f paaf
1338: WHERE ptp.payroll_id = paaf.payroll_id
1339: AND paaf.assignment_id = p_assignment_id
1340: AND ptp.end_date < p_effective_start_date ;
1341:

Line 1353: ,per_all_assignments_f paaf

1349: )
1350: IS
1351: SELECT min(ptp.end_date) next_payroll_date
1352: FROM per_time_periods ptp
1353: ,per_all_assignments_f paaf
1354: WHERE ptp.payroll_id = paaf.payroll_id
1355: AND paaf.assignment_id = p_assignment_id
1356: AND ptp.end_date >= p_effective_start_date ;
1357:

Line 1374: ,per_all_assignments_f paa

1370: ,pps.actual_termination_date actual_termination_date
1371: ,pps.last_standard_process_date last_standard_process_date
1372: ,pps.final_process_date final_process_date
1373: FROM per_periods_of_service_v pps
1374: ,per_all_assignments_f paa
1375: WHERE paa.person_id = pps.person_id
1376: AND paa.assignment_id = p_assignment_id
1377: AND paa.effective_end_date = pps.actual_termination_date
1378: AND pps.date_start <= p_effective_end_date