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

Line 355: per_assignment_status_types past

351: FROM pay_assignment_actions act,
352: per_all_assignments_f paa,
353: per_all_people_f pap,
354: per_periods_of_service serv,
355: per_assignment_status_types past
356: where act.assignment_action_id = p_assactid
357: and act.assignment_id = paa.assignment_id
358: and paa.assignment_status_type_id = past.assignment_status_type_id
359: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 388: per_assignment_status_types past

384: FROM pay_assignment_actions act,
385: per_all_assignments_f paa,
386: per_all_people_f pap,
387: per_periods_of_service serv,
388: per_assignment_status_types past
389: where act.assignment_action_id = p_assactid
390: and act.assignment_id = paa.assignment_id
391: and paa.assignment_status_type_id = past.assignment_status_type_id
392: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 528: per_assignment_status_types past,

524: per_all_people_f peo,
525: per_all_people_f peo1,
526: per_all_assignments_f paaf,
527: per_all_assignments_f paaf1,
528: per_assignment_status_types past,
529: per_assignment_status_types past1,
530: pay_all_payrolls_f papf ,
531: pay_all_payrolls_f papf1,
532: hr_soft_coding_keyflex flex

Line 529: per_assignment_status_types past1,

525: per_all_people_f peo1,
526: per_all_assignments_f paaf,
527: per_all_assignments_f paaf1,
528: per_assignment_status_types past,
529: per_assignment_status_types past1,
530: pay_all_payrolls_f papf ,
531: pay_all_payrolls_f papf1,
532: hr_soft_coding_keyflex flex
533: where

Line 555: per_assignment_status_types pasts

551: and paaf.EFFECTIVE_END_DATE = paaf1.EFFECTIVE_START_DATE - 1
552: and paaf.assignment_id <> paaf1.assignment_id
553: and exists
554: (select '1' from per_all_assignments_f paafs,
555: per_assignment_status_types pasts
556: where paafs.assignment_id = paaf.assignment_id
557: and paafs.effective_start_date = paaf1.effective_start_date
558: and paafs.assignment_status_type_id = pasts.assignment_status_type_id
559: and pasts.per_system_status in ('TERM_ASSIGN')

Line 569: per_assignment_status_types past

565: from
566: per_all_assignments_f paaf,
567: pay_all_payrolls_f papf ,
568: hr_soft_coding_keyflex flex,
569: per_assignment_status_types past
570: where
571: paaf.assignment_id = p_person_rec.assignment_id
572: and papf.payroll_id = paaf.payroll_id
573: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID

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

574: and upper(p_tax_ref) = upper(flex.segment1)
575: and paaf.assignment_status_type_id = past.assignment_status_type_id
576: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
577: and paaf.effective_start_date =
578: (select max(paaf1.effective_start_date) from per_all_assignments_f paaf1,per_assignment_status_types past1
579: where paaf1.assignment_id = paaf.assignment_id
580: and paaf1.assignment_type = 'E'
581: and paaf1.assignment_status_type_id = past1.assignment_status_type_id
582: and past1.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 1777: per_assignment_status_types past,

1773: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
1774: pap.person_id person_id,past.per_system_status status
1775: from per_all_people_f pap,
1776: per_all_assignments_f asg,
1777: per_assignment_status_types past,
1778: per_periods_of_service serv,
1779: pay_all_payrolls_f pay,
1780: hr_soft_coding_keyflex sck
1781: where pap.person_id between stperson and endperson

Line 1851: per_assignment_status_types past,

1847: select paaf.assignment_id
1848: from per_all_people_f peo,
1849: per_all_assignments_f paaf,
1850: per_all_assignments_f paaf1,
1851: per_assignment_status_types past,
1852: per_assignment_status_types past1,
1853: pay_all_payrolls_f papf ,
1854: hr_soft_coding_keyflex flex
1855: where

Line 1852: per_assignment_status_types past1,

1848: from per_all_people_f peo,
1849: per_all_assignments_f paaf,
1850: per_all_assignments_f paaf1,
1851: per_assignment_status_types past,
1852: per_assignment_status_types past1,
1853: pay_all_payrolls_f papf ,
1854: hr_soft_coding_keyflex flex
1855: where
1856: peo.person_id = p_person_id

Line 1872: per_assignment_status_types past

1868:
1869: cursor csr_get_terminated_date(p_asg_id number) is
1870: select max(effective_end_date)
1871: from per_all_assignments_f paaf ,
1872: per_assignment_status_types past
1873: where assignment_id = p_asg_id
1874: --and paaf.assignment_status_type_id in ( 1,2)
1875: and paaf.assignment_status_type_id = past.assignment_status_type_id
1876: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 2880: per_assignment_status_types past,

2876: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
2877: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
2878: pap.person_id
2879: from per_all_assignments_f paa,
2880: per_assignment_status_types past,
2881: per_all_people_f pap
2882: where paa.person_id = pap.person_id
2883: and paa.assignment_id = c_assignment_id
2884: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID

Line 2900: per_assignment_status_types past,

2896: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
2897: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
2898: pap.person_id
2899: from per_all_assignments_f paa,
2900: per_assignment_status_types past,
2901: per_all_people_f pap
2902: ,pay_payroll_actions ppa
2903: where paa.person_id = pap.person_id
2904: and paa.assignment_id = c_assignment_id

Line 2931: per_assignment_status_types past,

2927: to_char(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
2928: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
2929: pap.person_id
2930: from per_all_assignments_f paa,
2931: per_assignment_status_types past,
2932: per_all_people_f pap
2933: where paa.person_id = pap.person_id
2934: and paa.assignment_id = c_assignment_id
2935: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID

Line 3323: per_assignment_status_types past

3319: select paaf.effective_start_date from
3320: per_all_assignments_f paaf,
3321: pay_all_payrolls_f papf ,
3322: hr_soft_coding_keyflex flex,
3323: per_assignment_status_types past
3324: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
3325: and papf.payroll_id = paaf.payroll_id
3326: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
3327: and upper(l_tax_ref) = upper(flex.segment1)

Line 3352: per_assignment_status_types past

3348: from
3349: per_all_assignments_f paaf,
3350: pay_all_payrolls_f papf ,
3351: hr_soft_coding_keyflex flex,
3352: per_assignment_status_types past
3353: where paaf.assignment_id = asg_id and paaf.effective_start_date = eff_date + 1
3354: and papf.payroll_id = paaf.payroll_id
3355: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
3356: and upper(l_tax_ref) = upper(flex.segment1)