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_FPS dependencies on HR_SOFT_CODING_KEYFLEX

Line 415: hr_soft_coding_keyflex sck

411: cursor csr_asg is
412: select paaf.assignment_id
413: from per_all_assignments_f paaf,
414: pay_payrolls_f pay,
415: hr_soft_coding_keyflex sck
416: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_assignment_id)
417: and pay.payroll_id = paaf.payroll_id
418: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
419: and sck.SEGMENT1 = g_tax_ref

Line 1569: hr_soft_coding_keyflex sck

1565: SELECT min(paaf.effective_start_date) min_active_start_date
1566: FROM per_all_assignments_f paaf,
1567: per_assignment_status_types past,
1568: pay_all_payrolls_f pay,
1569: hr_soft_coding_keyflex sck
1570: WHERE paaf.assignment_id = p_asg_id
1571: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1572: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
1573: AND paaf.payroll_id = pay.payroll_id

Line 2377: hr_soft_coding_keyflex sck

2373: SELECT min(paaf.effective_start_date) min_active_start_date
2374: FROM per_all_assignments_f paaf,
2375: per_assignment_status_types past,
2376: pay_all_payrolls_f pay,
2377: hr_soft_coding_keyflex sck
2378: WHERE paaf.assignment_id = p_asg_id
2379: AND paaf.assignment_status_type_id = past.assignment_status_type_id
2380: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2381: AND paaf.payroll_id = pay.payroll_id

Line 3191: hr_soft_coding_keyflex sck

3187: SELECT min(paaf.effective_start_date) min_active_start_date
3188: FROM per_all_assignments_f paaf,
3189: per_assignment_status_types past,
3190: pay_all_payrolls_f pay,
3191: hr_soft_coding_keyflex sck
3192: WHERE paaf.assignment_id = p_asg_id
3193: AND paaf.assignment_status_type_id = past.assignment_status_type_id
3194: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
3195: AND paaf.payroll_id = pay.payroll_id

Line 3785: hr_soft_coding_keyflex flex,

3781: cursor csr_get_start_date is
3782: select paaf.effective_start_date from
3783: per_all_assignments_f paaf,
3784: pay_all_payrolls_f papf ,
3785: hr_soft_coding_keyflex flex,
3786: per_assignment_status_types past
3787: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
3788: and papf.payroll_id = paaf.payroll_id
3789: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID

Line 6044: hr_soft_coding_keyflex flex

6040: and ppa.action_type in ('P','U')
6041: and ppa.action_status ='C'
6042: and ppa.payroll_id in (select distinct payroll_id
6043: from pay_all_payrolls_f papf,
6044: hr_soft_coding_keyflex flex
6045: where upper(flex.segment1) = c_tax_ref
6046: and flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID)
6047: minus
6048: select distinct pre_payment_payroll_action_id from pay_gb_bacs_fps;

Line 6628: hr_soft_coding_keyflex flex

6624: pay_assignment_actions act1, --Prepayments
6625: pay_action_interlocks pai, --Prepayments
6626: per_all_assignments_f as1,
6627: pay_all_payrolls_f papf ,
6628: hr_soft_coding_keyflex flex
6629: WHERE as1.person_id = p_person_id --58105
6630: AND appa.action_type IN ('R','Q','V','B') -- Payroll Run or Quickpay Run
6631: AND act.payroll_action_id = appa.payroll_action_id
6632: AND act.source_action_id IS NULL