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 132: ,assignment_id per_all_assignments_f.assignment_id%TYPE

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

Line 137: ,new_location_id per_all_assignments_f.location_id%TYPE

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

Line 152: ,assignment_id per_all_assignments_f.assignment_id%TYPE

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

Line 164: ( assignment_id per_all_assignments_f.assignment_id%TYPE

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

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

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

Line 270: FROM per_all_assignments_f asg, per_assignment_status_types pss

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

Line 294: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 367: FROM per_all_assignments_f asg

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

Line 379: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 406: FROM per_all_assignments_f asg

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

Line 463: FROM per_all_assignments_f asg

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

Line 508: FROM per_all_assignments_f asg

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

Line 621: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 659: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 1316: ,per_all_assignments_f paaf

1312: )
1313: IS
1314: SELECT max(ptp.end_date) previous_payroll_date
1315: FROM per_time_periods ptp
1316: ,per_all_assignments_f paaf
1317: WHERE ptp.payroll_id = paaf.payroll_id
1318: AND paaf.assignment_id = p_assignment_id
1319: AND ptp.end_date <= p_effective_start_date ;
1320:

Line 1332: ,per_all_assignments_f paaf

1328: )
1329: IS
1330: SELECT min(ptp.end_date) next_payroll_date
1331: FROM per_time_periods ptp
1332: ,per_all_assignments_f paaf
1333: WHERE ptp.payroll_id = paaf.payroll_id
1334: AND paaf.assignment_id = p_assignment_id
1335: AND ptp.end_date >= p_effective_start_date ;
1336:

Line 1353: ,per_all_assignments_f paa

1349: ,pps.actual_termination_date actual_termination_date
1350: ,pps.last_standard_process_date last_standard_process_date
1351: ,pps.final_process_date final_process_date
1352: FROM per_periods_of_service_v pps
1353: ,per_all_assignments_f paa
1354: WHERE paa.person_id = pps.person_id
1355: AND paa.assignment_id = p_assignment_id
1356: AND paa.effective_end_date = pps.actual_termination_date
1357: AND pps.date_start <= p_effective_end_date