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 HR_SOFT_CODING_KEYFLEX

Line 532: hr_soft_coding_keyflex flex

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
534: peo.person_id = p_person_id
535: and paaf.person_id = peo.person_id
536: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 568: hr_soft_coding_keyflex flex,

564: select paaf.effective_start_date,paaf.effective_end_date
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

Line 1780: hr_soft_coding_keyflex sck

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
1782: and pap.current_employee_flag = 'Y'
1783: and pap.person_id = asg.person_id
1784: and asg.business_group_id = l_business_group_id

Line 1811: hr_soft_coding_keyflex sck

1807: from per_all_people_f pap,
1808: per_all_assignments_f asg,
1809: per_periods_of_service serv,
1810: pay_all_payrolls_f pay,
1811: hr_soft_coding_keyflex sck
1812: where pap.person_id between stperson and endperson
1813: and serv.actual_termination_date is not null
1814: and pap.person_id = asg.person_id
1815: and asg.business_group_id = l_business_group_id

Line 1854: hr_soft_coding_keyflex flex

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
1857: and paaf.person_id = peo.person_id
1858: and paaf.assignment_id <> p_assignment_id

Line 2067: hr_soft_coding_keyflex sck,

2063: from per_all_people_f pap,
2064: per_all_assignments_f asg,
2065: per_periods_of_service serv,
2066: pay_all_payrolls_f pay,
2067: hr_soft_coding_keyflex sck,
2068: per_people_extra_info ppei
2069: where pap.person_id between stperson and endperson
2070: and pap.person_id =ppei.person_id (+)
2071: /* and nvl(ppei.pei_information_category,'RTI_NINO') = 'RTI_NINO'

Line 2372: hr_soft_coding_keyflex sck

2368: is
2369: select paaf.assignment_id
2370: from per_all_assignments_f paaf,
2371: pay_payrolls_f pay,
2372: hr_soft_coding_keyflex sck
2373: where paaf.person_id = l_archive_tab(0).person_id
2374: and paaf.assignment_id <> l_archive_tab(0).assignment_id
2375: and pay.payroll_id = paaf.payroll_id
2376: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

Line 3322: hr_soft_coding_keyflex flex,

3318: cursor csr_get_start_date is
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

Line 3351: hr_soft_coding_keyflex flex,

3347: select paaf.effective_end_date
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