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 328: FROM per_assignments_f

324: location_id,
325: business_group_id,
326: soft_coding_keyflex_id,
327: effective_end_date) gre_id
328: FROM per_assignments_f
329: WHERE assignment_id = p_assignment_id;
330:
331: /*Added to check for the applicant type */
332: CURSOR c_check_per_status (p_person_id IN VARCHAR2 ,

Line 2423: FROM per_assignments_f paf

2419: WHERE assignment_status_type_id = cp_asg_status_type_id;
2420:
2421: CURSOR csr_asg_exists (cp_effective_date DATE) IS
2422: SELECT 'X'
2423: FROM per_assignments_f paf
2424: WHERE paf.assignment_id = p_assignment_id
2425: AND cp_effective_date BETWEEN paf.effective_start_date
2426: AND paf.effective_end_date
2427: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 2437: FROM per_assignments_f paf,

2433:
2434: CURSOR csr_per_gre (cp_effective_date DATE,
2435: cp_tran_type VARCHAR2) IS
2436: SELECT 'Y'
2437: FROM per_assignments_f paf,
2438: per_assignment_status_types pst
2439: WHERE paf.person_id = p_person_id
2440: --AND paf.assignment_id <> p_assignment_id
2441: AND paf.assignment_status_type_id = pst.assignment_status_type_id

Line 3283: FROM per_assignments_f pa

3279: ,paf.effective_end_date desc;
3280:
3281: CURSOR csr_get_asg_end_date (cp_effective_date DATE) IS
3282: SELECT effective_end_date
3283: FROM per_assignments_f pa
3284: WHERE pa.assignment_id = p_assignment_id
3285: AND pa.effective_end_date = cp_effective_date
3286: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3287: location_id

Line 3597: FROM per_assignments_f paf

3593:
3594: CURSOR csr_asg_dates IS
3595: SELECT paf.effective_start_date,
3596: paf.effective_end_date
3597: FROM per_assignments_f paf
3598: WHERE paf.assignment_id = p_assignment_id
3599: AND paf.effective_start_date = (SELECT max(paf_in.effective_start_date)
3600: FROM per_assignments_f paf_in
3601: WHERE paf_in.assignment_id =

Line 3600: FROM per_assignments_f paf_in

3596: paf.effective_end_date
3597: FROM per_assignments_f paf
3598: WHERE paf.assignment_id = p_assignment_id
3599: AND paf.effective_start_date = (SELECT max(paf_in.effective_start_date)
3600: FROM per_assignments_f paf_in
3601: WHERE paf_in.assignment_id =
3602: paf.assignment_id
3603: -- Bug 5908010
3604: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4058: FROM per_assignments_f paf,

4054: IF gn_implementation = 0 THEN
4055:
4056: p_sqlstr :=
4057: 'SELECT DISTINCT paf.person_id
4058: FROM per_assignments_f paf,
4059: pay_payroll_actions ppa
4060: WHERE ppa.payroll_action_id = :p_payroll_action_id
4061: AND paf.business_group_id = ppa.business_group_id
4062: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4076: FROM per_assignments_f paf

4072:
4073: p_sqlstr :=
4074: 'SELECT DISTINCT person_id FROM ( '||
4075: 'SELECT paf.person_id
4076: FROM per_assignments_f paf
4077: ,pay_payroll_actions ppa
4078: WHERE ppa.payroll_action_id = :p_payroll_action_id
4079: AND paf.business_group_id = ppa.business_group_id
4080: AND per_mx_ssaffl_archive.derive_gre_from_loc_scl(

Line 4102: FROM per_assignments_f paf

4098:
4099: p_sqlstr := p_sqlstr ||
4100: ') UNION ALL '||
4101: 'SELECT paf.person_id
4102: FROM per_assignments_f paf
4103: ,pay_payroll_actions ppa
4104: ,pay_element_entries_f pee
4105: ,pay_sub_classification_rules_f psc
4106: ,pay_element_classifications pec

Line 4194: ,per_assignments_f paf

4190: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4191: ,paf.assignment_id
4192: ,'N' variable_idw
4193: FROM pay_payroll_actions ppa
4194: ,per_assignments_f paf
4195: WHERE ppa.payroll_action_id = cp_payroll_action_id
4196: AND ppa.business_group_id = cp_business_group_id
4197: AND paf.business_group_id = ppa.business_group_id
4198: AND paf.person_id BETWEEN cp_start_person_id

Line 4210: FROM per_assignments_f paf

4206: SELECT paf.person_id
4207: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4208: ,paf.assignment_id
4209: ,'Y' variable_idw
4210: FROM per_assignments_f paf
4211: ,pay_payroll_actions ppa
4212: ,pay_element_entries_f pee
4213: ,pay_sub_classification_rules_f psc
4214: ,pay_element_classifications pec

Line 4278: ,per_assignments_f paf

4274: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4275: ,paf.assignment_id
4276: ,'N' variable_idw
4277: FROM pay_payroll_actions ppa
4278: ,per_assignments_f paf
4279: ,pay_population_ranges ppr
4280: WHERE ppa.payroll_action_id = cp_payroll_action_id
4281: AND ppr.payroll_action_id = ppa.payroll_action_id
4282: AND ppr.chunk_number = cp_chunk_number

Line 4295: ,per_assignments_f paf

4291: ,decode(paf.primary_flag, 'Y', 'Y', 'Z')
4292: ,paf.assignment_id
4293: ,'Y' variable_idw
4294: FROM pay_payroll_actions ppa
4295: ,per_assignments_f paf
4296: ,pay_population_ranges ppr
4297: ,pay_element_entries_f pee
4298: ,pay_sub_classification_rules_f psc
4299: ,pay_element_classifications pec