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_GB_RTI_EAS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 299: per_assignment_status_types past

295: FROM pay_assignment_actions act,
296: per_all_assignments_f paa,
297: per_all_people_f pap,
298: per_periods_of_service serv,
299: per_assignment_status_types past
300: where act.assignment_action_id = p_assactid
301: and act.assignment_id = paa.assignment_id
302: and paa.assignment_status_type_id = past.assignment_status_type_id
303: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 332: per_assignment_status_types past

328: FROM pay_assignment_actions act,
329: per_all_assignments_f paa,
330: per_all_people_f pap,
331: per_periods_of_service serv,
332: per_assignment_status_types past
333: where act.assignment_action_id = p_assactid
334: and act.assignment_id = paa.assignment_id
335: and paa.assignment_status_type_id = past.assignment_status_type_id
336: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 914: per_assignment_status_types past,

910: per_all_people_f peo,
911: per_all_people_f peo1,
912: per_all_assignments_f paaf,
913: per_all_assignments_f paaf1,
914: per_assignment_status_types past,
915: per_assignment_status_types past1,
916: pay_all_payrolls_f papf ,
917: pay_all_payrolls_f papf1,
918: hr_soft_coding_keyflex flex

Line 915: per_assignment_status_types past1,

911: per_all_people_f peo1,
912: per_all_assignments_f paaf,
913: per_all_assignments_f paaf1,
914: per_assignment_status_types past,
915: per_assignment_status_types past1,
916: pay_all_payrolls_f papf ,
917: pay_all_payrolls_f papf1,
918: hr_soft_coding_keyflex flex
919: where

Line 941: per_assignment_status_types pasts

937: and paaf.EFFECTIVE_END_DATE = paaf1.EFFECTIVE_START_DATE - 1
938: and paaf.assignment_id <> paaf1.assignment_id
939: and exists
940: (select '1' from per_all_assignments_f paafs,
941: per_assignment_status_types pasts
942: where paafs.assignment_id = paaf.assignment_id
943: and paafs.effective_start_date = paaf1.effective_start_date
944: and paafs.assignment_status_type_id = pasts.assignment_status_type_id
945: and pasts.per_system_status in ('TERM_ASSIGN')

Line 955: per_assignment_status_types past

951: from
952: per_all_assignments_f paaf,
953: pay_all_payrolls_f papf ,
954: hr_soft_coding_keyflex flex,
955: per_assignment_status_types past
956: where
957: paaf.assignment_id = p_person_rec.assignment_id
958: and papf.payroll_id = paaf.payroll_id
959: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID

Line 964: (select max(paaf1.effective_start_date) from per_all_assignments_f paaf1,per_assignment_status_types past1

960: and upper(p_tax_ref) = upper(flex.segment1)
961: and paaf.assignment_status_type_id = past.assignment_status_type_id
962: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
963: and paaf.effective_start_date =
964: (select max(paaf1.effective_start_date) from per_all_assignments_f paaf1,per_assignment_status_types past1
965: where paaf1.assignment_id = paaf.assignment_id
966: and paaf1.assignment_type = 'E'
967: and paaf1.assignment_status_type_id = past1.assignment_status_type_id
968: and past1.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 2391: per_assignment_status_types past,

2387: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
2388: pap.person_id person_id,past.per_system_status status
2389: from per_all_people_f pap,
2390: per_all_assignments_f asg,
2391: per_assignment_status_types past,
2392: per_periods_of_service serv,
2393: pay_all_payrolls_f pay,
2394: hr_soft_coding_keyflex sck,
2395: hr_organization_information org

Line 2481: per_assignment_status_types past,

2477: select paaf.assignment_id
2478: from per_all_people_f peo,
2479: per_all_assignments_f paaf,
2480: per_all_assignments_f paaf1,
2481: per_assignment_status_types past,
2482: per_assignment_status_types past1,
2483: pay_all_payrolls_f papf ,
2484: hr_soft_coding_keyflex flex
2485: where

Line 2482: per_assignment_status_types past1,

2478: from per_all_people_f peo,
2479: per_all_assignments_f paaf,
2480: per_all_assignments_f paaf1,
2481: per_assignment_status_types past,
2482: per_assignment_status_types past1,
2483: pay_all_payrolls_f papf ,
2484: hr_soft_coding_keyflex flex
2485: where
2486: peo.person_id = p_person_id

Line 2502: per_assignment_status_types past

2498:
2499: cursor csr_get_terminated_date(p_asg_id number) is
2500: select max(effective_end_date)
2501: from per_all_assignments_f paaf ,
2502: per_assignment_status_types past
2503: where assignment_id = p_asg_id
2504: --and paaf.assignment_status_type_id in ( 1,2)
2505: and paaf.assignment_status_type_id = past.assignment_status_type_id
2506: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 3709: per_assignment_status_types past,

3705: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
3706: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
3707: pap.person_id
3708: from per_all_assignments_f paa,
3709: per_assignment_status_types past,
3710: per_all_people_f pap
3711: ,pay_payroll_actions ppa
3712: where paa.person_id = pap.person_id
3713: and paa.assignment_id = c_assignment_id

Line 3741: per_assignment_status_types past,

3737: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
3738: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
3739: pap.person_id
3740: from per_all_assignments_f paa,
3741: per_assignment_status_types past,
3742: per_all_people_f pap
3743: where paa.person_id = pap.person_id
3744: and paa.assignment_id = c_assignment_id
3745: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID

Line 4220: per_assignment_status_types past

4216: select paaf.effective_start_date from
4217: per_all_assignments_f paaf,
4218: pay_all_payrolls_f papf ,
4219: hr_soft_coding_keyflex flex,
4220: per_assignment_status_types past
4221: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
4222: and papf.payroll_id = paaf.payroll_id
4223: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
4224: and upper(l_tax_ref) = upper(flex.segment1)

Line 4249: per_assignment_status_types past

4245: from
4246: per_all_assignments_f paaf,
4247: pay_all_payrolls_f papf ,
4248: hr_soft_coding_keyflex flex,
4249: per_assignment_status_types past
4250: where paaf.assignment_id = asg_id and paaf.effective_start_date = eff_date + 1
4251: and papf.payroll_id = paaf.payroll_id
4252: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
4253: and upper(l_tax_ref) = upper(flex.segment1)