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.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PER_ALL_ASSIGNMENTS_F

Line 201: FROM per_all_assignments_f paf

197: cp_effective_date DATE)
198: IS
199: SELECT paf.person_id,
200: paf.object_version_number
201: FROM per_all_assignments_f paf
202: WHERE paf.assignment_id = cp_assignment_id
203: AND cp_effective_date BETWEEN effective_start_date
204: AND effective_end_date;
205:

Line 307: per_all_assignments_f paf

303: cp_effective_date DATE)
304: IS
305: SELECT hsck.segment18
306: FROM hr_soft_coding_keyflex hsck,
307: per_all_assignments_f paf
308: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
309: AND paf.assignment_id = cp_assignment_id
310: AND cp_effective_date BETWEEN paf.effective_start_date
311: AND paf.effective_end_date;

Line 316: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

312:
313:
314: lv_procedure_name VARCHAR2(100) := '.update_asg_data';
315:
316: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
317: ln_person_id per_all_assignments_f.person_id%TYPE;
318: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
319: ld_effective_date DATE;
320: ld_date_earned DATE;

Line 317: ln_person_id per_all_assignments_f.person_id%TYPE;

313:
314: lv_procedure_name VARCHAR2(100) := '.update_asg_data';
315:
316: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
317: ln_person_id per_all_assignments_f.person_id%TYPE;
318: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
319: ld_effective_date DATE;
320: ld_date_earned DATE;
321: lv_legislation_code VARCHAR2(2);

Line 318: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;

314: lv_procedure_name VARCHAR2(100) := '.update_asg_data';
315:
316: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
317: ln_person_id per_all_assignments_f.person_id%TYPE;
318: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
319: ld_effective_date DATE;
320: ld_date_earned DATE;
321: lv_legislation_code VARCHAR2(2);
322:

Line 353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

349: lv_resident_city pay_us_city_names.city_name%TYPE;
350: lv_resident_zip_code pay_us_zip_codes.zip_start%TYPE;
351:
352: lv_datetrack_update_mode VARCHAR2(50) := 'CORRECTION';
353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
354: ln_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
355: lv_cagr_concatenated_segments VARCHAR2(2000);
356: ln_comment_id per_all_assignments_f.comment_id%TYPE;
357: ln_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;

Line 354: ln_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;

350: lv_resident_zip_code pay_us_zip_codes.zip_start%TYPE;
351:
352: lv_datetrack_update_mode VARCHAR2(50) := 'CORRECTION';
353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
354: ln_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
355: lv_cagr_concatenated_segments VARCHAR2(2000);
356: ln_comment_id per_all_assignments_f.comment_id%TYPE;
357: ln_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
358: ld_effective_start_date DATE;

Line 356: ln_comment_id per_all_assignments_f.comment_id%TYPE;

352: lv_datetrack_update_mode VARCHAR2(50) := 'CORRECTION';
353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
354: ln_cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE;
355: lv_cagr_concatenated_segments VARCHAR2(2000);
356: ln_comment_id per_all_assignments_f.comment_id%TYPE;
357: ln_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%TYPE;
358: ld_effective_start_date DATE;
359: ld_effective_end_date DATE;
360: lv_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 366: ln_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

362: lb_other_manager_warning BOOLEAN;
363: lb_hourly_salaried_warning BOOLEAN;
364: lb_gsp_post_process_warning VARCHAR2(2000);
365:
366: ln_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
367: ln_people_group_id per_all_assignments_f.people_group_id%TYPE;
368: lv_group_name pay_people_groups.group_name%TYPE;
369: lb_spp_delete_warning BOOLEAN;
370: lv_entries_changed_warning VARCHAR2(10);

Line 367: ln_people_group_id per_all_assignments_f.people_group_id%TYPE;

363: lb_hourly_salaried_warning BOOLEAN;
364: lb_gsp_post_process_warning VARCHAR2(2000);
365:
366: ln_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
367: ln_people_group_id per_all_assignments_f.people_group_id%TYPE;
368: lv_group_name pay_people_groups.group_name%TYPE;
369: lb_spp_delete_warning BOOLEAN;
370: lv_entries_changed_warning VARCHAR2(10);
371: lb_tax_dist_changed_warning BOOLEAN;

Line 1173: per_all_assignments_f asg

1169: SELECT NVL(addr.add_information17,addr.region_2) state_abbrev,
1170: NVL(addr.add_information19,addr.region_1) county_name,
1171: NVL(addr.add_information18,addr.town_or_city) city_name
1172: from per_addresses addr,
1173: per_all_assignments_f asg
1174: WHERE cp_effective_date BETWEEN asg.effective_start_date
1175: AND asg.effective_end_date
1176: AND asg.assignment_id = cp_assignment_id
1177: AND addr.person_id = asg.person_id

Line 2263: FROM per_all_assignments_f peaf,

2259: || '-'
2260: || puc.county_code
2261: || '-'
2262: || punc.city_code
2263: FROM per_all_assignments_f peaf,
2264: hr_locations_all hla,
2265: pay_us_states pus,
2266: pay_us_counties puc,
2267: pay_us_city_names punc

Line 2873: FROM per_all_assignments_f paf

2869: CURSOR get_person_id(cp_assignment_id NUMBER,
2870: cp_effective_date DATE)
2871: IS
2872: SELECT paf.person_id
2873: FROM per_all_assignments_f paf
2874: WHERE paf.assignment_id = cp_assignment_id
2875: AND cp_effective_date BETWEEN paf.effective_start_date
2876: AND paf.effective_end_date;
2877:

Line 2947: ln_person_id per_all_assignments_f.person_id%TYPE;

2943: lv_ytd_taxable_benefits VARCHAR2(80):= 0;
2944: lv_ytd_alien_expat_earnings VARCHAR2(80):= 0;
2945:
2946: ln_index NUMBER;
2947: ln_person_id per_all_assignments_f.person_id%TYPE;
2948:
2949: lv_error_message VARCHAR2(200);
2950: ln_step NUMBER;
2951:

Line 3465: FROM per_all_assignments_f paf

3461: cp_effective_date DATE)
3462: IS
3463: SELECT DISTINCT paf.organization_id,
3464: paf.business_group_id
3465: FROM per_all_assignments_f paf
3466: WHERE paf.payroll_id = cp_payroll_id
3467: AND paf.assignment_id = cp_assignment_id
3468: AND cp_effective_date BETWEEN paf.effective_start_date
3469: AND paf.effective_end_date;

Line 3482: ln_organization_id per_all_assignments_f.organization_id%TYPE;

3478: ORDER BY psi.action_context_id DESC;
3479:
3480: lv_procedure_name VARCHAR2(100) := '.archive_payroll_level_data';
3481:
3482: ln_organization_id per_all_assignments_f.organization_id%TYPE;
3483: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
3484: ln_tax_unit_id per_all_assignments_f.organization_id%TYPE;
3485:
3486: BEGIN

Line 3483: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;

3479:
3480: lv_procedure_name VARCHAR2(100) := '.archive_payroll_level_data';
3481:
3482: ln_organization_id per_all_assignments_f.organization_id%TYPE;
3483: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
3484: ln_tax_unit_id per_all_assignments_f.organization_id%TYPE;
3485:
3486: BEGIN
3487:

Line 3484: ln_tax_unit_id per_all_assignments_f.organization_id%TYPE;

3480: lv_procedure_name VARCHAR2(100) := '.archive_payroll_level_data';
3481:
3482: ln_organization_id per_all_assignments_f.organization_id%TYPE;
3483: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
3484: ln_tax_unit_id per_all_assignments_f.organization_id%TYPE;
3485:
3486: BEGIN
3487:
3488: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

Line 4555: FROM per_all_assignments_f paaf,

4551: SELECT paaf.person_id,
4552: paaf.business_group_id,
4553: paaf.payroll_id,
4554: paaf.pay_basis_id
4555: FROM per_all_assignments_f paaf,
4556: fnd_sessions fs
4557: WHERE paaf.assignment_id = cp_assignment_id
4558: AND cp_effective_date BETWEEN paaf.effective_start_date
4559: AND paaf.effective_end_date;

Line 4629: ln_person_id per_all_assignments_f.person_id%TYPE;

4625:
4626: ld_last_payslip_date DATE;
4627: ln_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
4628:
4629: ln_person_id per_all_assignments_f.person_id%TYPE;
4630: ln_payroll_id per_all_assignments_f.payroll_id%TYPE;
4631: ln_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
4632:
4633: lv_period_type pay_payrolls_f.period_type%TYPE;

Line 4630: ln_payroll_id per_all_assignments_f.payroll_id%TYPE;

4626: ld_last_payslip_date DATE;
4627: ln_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
4628:
4629: ln_person_id per_all_assignments_f.person_id%TYPE;
4630: ln_payroll_id per_all_assignments_f.payroll_id%TYPE;
4631: ln_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
4632:
4633: lv_period_type pay_payrolls_f.period_type%TYPE;
4634: lv_pay_basis per_pay_bases.name%TYPE;

Line 4631: ln_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

4627: ln_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
4628:
4629: ln_person_id per_all_assignments_f.person_id%TYPE;
4630: ln_payroll_id per_all_assignments_f.payroll_id%TYPE;
4631: ln_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
4632:
4633: lv_period_type pay_payrolls_f.period_type%TYPE;
4634: lv_pay_basis per_pay_bases.name%TYPE;
4635:

Line 4856: FROM per_all_assignments_f asgt

4852: AND pesm.element_type_id = pet.element_type_id
4853: )
4854: AND EXISTS
4855: (SELECT NULL
4856: FROM per_all_assignments_f asgt
4857: WHERE asgt.assignment_id = p_assignment_id
4858: AND ld_effective_date BETWEEN asgt.effective_start_date
4859: AND asgt.effective_end_date
4860: AND asgt.business_group_id = pel.business_group_id