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 HR_SOFT_CODING_KEYFLEX

Line 918: hr_soft_coding_keyflex flex

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
920: peo.person_id = p_person_id
921: and paaf.person_id = peo.person_id
922: and paaf.assignment_status_type_id = past.assignment_status_type_id

Line 954: hr_soft_coding_keyflex flex,

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

Line 2394: hr_soft_coding_keyflex sck,

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
2396: where pap.person_id between stperson and endperson
2397: and pap.current_employee_flag = 'Y'
2398: and pap.person_id = asg.person_id

Line 2433: hr_soft_coding_keyflex sck,

2429: from per_all_people_f pap,
2430: per_all_assignments_f asg,
2431: per_periods_of_service serv,
2432: pay_all_payrolls_f pay,
2433: hr_soft_coding_keyflex sck,
2434: hr_organization_information org
2435: where pap.person_id between stperson and endperson
2436: and serv.actual_termination_date is not null
2437: and pap.person_id = asg.person_id

Line 2484: hr_soft_coding_keyflex flex

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

Line 2717: hr_soft_coding_keyflex sck,

2713: from per_all_people_f pap,
2714: per_all_assignments_f asg,
2715: per_periods_of_service serv,
2716: pay_all_payrolls_f pay,
2717: hr_soft_coding_keyflex sck,
2718: per_people_extra_info ppei
2719: where pap.person_id between stperson and endperson
2720: and pap.person_id =ppei.person_id (+)
2721: and nvl(ppei.pei_information_category,'RTI_NINO') = 'RTI_NINO'

Line 3094: hr_soft_coding_keyflex sck

3090: is
3091: select asg.assignment_id
3092: from per_all_assignments_f asg,
3093: pay_payrolls_f pay,
3094: hr_soft_coding_keyflex sck
3095: where asg.person_id = p_person_id
3096: and asg.business_group_id = p_business_group_id
3097: and pay.payroll_id=asg.payroll_id
3098: and pay.SOFT_CODING_KEYFLEX_ID=sck.SOFT_CODING_KEYFLEX_ID

Line 4219: hr_soft_coding_keyflex flex,

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

Line 4248: hr_soft_coding_keyflex flex,

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