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_MX_SOC_SEC_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 364: FROM per_assignments_f

360: location_id,
361: business_group_id,
362: soft_coding_keyflex_id,
363: effective_end_date) gre_id
364: FROM per_assignments_f
365: WHERE assignment_id = p_assignment_id;
366:
367: /*Added to check for the applicant type */
368: CURSOR c_check_per_status (p_person_id IN VARCHAR2 ,

Line 2547: FROM per_assignments_f paf

2543: WHERE assignment_status_type_id = cp_asg_status_type_id;
2544:
2545: CURSOR csr_asg_exists (cp_effective_date DATE) IS
2546: SELECT 'X'
2547: FROM per_assignments_f paf
2548: WHERE paf.assignment_id = p_assignment_id
2549: AND cp_effective_date BETWEEN paf.effective_start_date
2550: AND paf.effective_end_date
2551: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 2561: FROM per_assignments_f paf,

2557:
2558: CURSOR csr_per_gre (cp_effective_date DATE,
2559: cp_tran_type VARCHAR2) IS
2560: SELECT 'Y'
2561: FROM per_assignments_f paf,
2562: per_assignment_status_types pst
2563: WHERE paf.person_id = p_person_id
2564: --AND paf.assignment_id <> p_assignment_id
2565: AND paf.assignment_status_type_id = pst.assignment_status_type_id

Line 3485: FROM per_assignments_f pa

3481: ,paf.effective_end_date desc;
3482:
3483: CURSOR csr_get_asg_end_date (cp_effective_date DATE) IS
3484: SELECT effective_end_date
3485: FROM per_assignments_f pa
3486: WHERE pa.assignment_id = p_assignment_id
3487: AND pa.effective_end_date = cp_effective_date
3488: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3489: location_id

Line 3810: FROM per_assignments_f paf

3806:
3807: CURSOR csr_asg_dates IS
3808: SELECT paf.effective_start_date,
3809: paf.effective_end_date
3810: FROM per_assignments_f paf
3811: WHERE paf.assignment_id = p_assignment_id
3812: AND paf.effective_start_date = (SELECT max(paf_in.effective_start_date)
3813: FROM per_assignments_f paf_in
3814: WHERE paf_in.assignment_id =

Line 3813: FROM per_assignments_f paf_in

3809: paf.effective_end_date
3810: FROM per_assignments_f paf
3811: WHERE paf.assignment_id = p_assignment_id
3812: AND paf.effective_start_date = (SELECT max(paf_in.effective_start_date)
3813: FROM per_assignments_f paf_in
3814: WHERE paf_in.assignment_id =
3815: paf.assignment_id
3816: -- Bug 5908010
3817: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4447: FROM per_assignments_f paf,

4443: IF gn_implementation = 0 THEN
4444:
4445: p_sqlstr :=
4446: 'SELECT DISTINCT paf.person_id
4447: FROM per_assignments_f paf,
4448: pay_payroll_actions ppa
4449: WHERE ppa.payroll_action_id = :p_payroll_action_id
4450: AND paf.business_group_id = ppa.business_group_id
4451: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4466: FROM per_assignments_f paf

4462:
4463: p_sqlstr :=
4464: 'SELECT DISTINCT person_id FROM ( '||
4465: 'SELECT paf.person_id
4466: FROM per_assignments_f paf
4467: ,pay_payroll_actions ppa
4468: WHERE ppa.payroll_action_id = :p_payroll_action_id
4469: AND paf.business_group_id = ppa.business_group_id
4470: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4525: ,per_assignments_f paf

4521: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4522: ,paf.assignment_id
4523: ,'N' variable_idw
4524: FROM pay_payroll_actions ppa
4525: ,per_assignments_f paf
4526: WHERE ppa.payroll_action_id = cp_payroll_action_id
4527: AND ppa.business_group_id = cp_business_group_id
4528: AND paf.business_group_id = ppa.business_group_id
4529: AND paf.person_id BETWEEN cp_start_person_id

Line 4541: FROM per_assignments_f paf

4537: SELECT paf.person_id
4538: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4539: ,paf.assignment_id
4540: ,'Y' variable_idw
4541: FROM per_assignments_f paf
4542: ,pay_payroll_actions ppa
4543: ,pay_element_entries_f pee
4544: ,pay_sub_classification_rules_f psc
4545: ,pay_element_classifications pec

Line 4609: ,per_assignments_f paf

4605: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4606: ,paf.assignment_id
4607: ,'N' variable_idw
4608: FROM pay_payroll_actions ppa
4609: ,per_assignments_f paf
4610: ,pay_population_ranges ppr
4611: WHERE ppa.payroll_action_id = cp_payroll_action_id
4612: AND ppr.payroll_action_id = ppa.payroll_action_id
4613: AND ppr.chunk_number = cp_chunk_number

Line 4626: ,per_assignments_f paf

4622: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4623: ,paf.assignment_id
4624: ,'Y' variable_idw
4625: FROM pay_payroll_actions ppa
4626: ,per_assignments_f paf
4627: ,pay_population_ranges ppr
4628: ,pay_element_entries_f pee
4629: ,pay_sub_classification_rules_f psc
4630: ,pay_element_classifications pec

Line 4694: ,per_assignments_f paf

4690: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4691: ,paf.assignment_id
4692: ,'N' variable_idw
4693: FROM pay_payroll_actions ppa
4694: ,per_assignments_f paf
4695: WHERE ppa.payroll_action_id = cp_payroll_action_id
4696: AND ppa.business_group_id = cp_business_group_id
4697: AND paf.business_group_id = ppa.business_group_id
4698: AND paf.person_id BETWEEN cp_start_person_id

Line 4720: FROM per_assignments_f paf

4716: SELECT paf.person_id
4717: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4718: ,paf.assignment_id
4719: ,'Y' variable_idw
4720: FROM per_assignments_f paf
4721: ,pay_payroll_actions ppa
4722: WHERE ppa.payroll_action_id = cp_payroll_action_id
4723: AND ppa.business_group_id = cp_business_group_id
4724: AND paf.business_group_id = ppa.business_group_id

Line 4760: ,per_assignments_f paf

4756: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4757: ,paf.assignment_id
4758: ,'N' variable_idw
4759: FROM pay_payroll_actions ppa
4760: ,per_assignments_f paf
4761: ,pay_population_ranges ppr
4762: WHERE ppa.payroll_action_id = cp_payroll_action_id
4763: AND ppr.payroll_action_id = ppa.payroll_action_id
4764: AND ppr.chunk_number = cp_chunk_number

Line 4788: ,per_assignments_f paf

4784: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4785: ,paf.assignment_id
4786: ,'Y' variable_idw
4787: FROM pay_payroll_actions ppa
4788: ,per_assignments_f paf
4789: ,pay_population_ranges ppr
4790: WHERE ppa.payroll_action_id = cp_payroll_action_id
4791: AND ppr.payroll_action_id = ppa.payroll_action_id
4792: AND ppr.chunk_number = cp_chunk_number