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

Line 224: hr_soft_coding_keyflex flex,

220: substr(org.org_information2 ,1,40) tax_district_name,
221: substr(ltrim(org.org_information3),1,36) employers_name,
222: substr(ltrim(org.org_information4),1,60) employers_address_line
223: FROM pay_all_payrolls_f p,
224: hr_soft_coding_keyflex flex,
225: hr_organization_information org
226: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
227: AND org.org_information_context = 'Tax Details References'
228: AND org.org_information1 = flex.segment1

Line 680: hr_soft_coding_keyflex flex

676: max(paaf.effective_end_date) max_active
677: FROM per_all_assignments_f paaf,
678: per_assignment_status_types past,
679: pay_all_payrolls_f papf,
680: hr_soft_coding_keyflex flex
681: WHERE paaf.assignment_id = p_asg_id
682: AND paaf.assignment_status_type_id = past.assignment_status_type_id
683: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
684: AND paaf.payroll_id = papf.payroll_id

Line 3087: hr_soft_coding_keyflex flex,

3083: substr(ltrim(org.org_information4),1,60) employers_address_line, -- 4011263: added ltrim
3084: substr(nvl(flex.segment14,org.org_information7),1,9) econ
3085:
3086: FROM pay_all_payrolls_f p,
3087: hr_soft_coding_keyflex flex,
3088: hr_organization_information org
3089: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3090: AND org.org_information_context = 'Tax Details References'
3091: AND org.org_information1 = flex.segment1

Line 3107: hr_soft_coding_keyflex flex

3103: p_end_year DATE,
3104: p_paye_ref VARCHAR2) IS
3105: SELECT flex.segment1
3106: FROM pay_all_payrolls_f p,
3107: hr_soft_coding_keyflex flex
3108: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
3109: AND p.payroll_id = p_payroll_id
3110: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
3111: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)

Line 3114: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

3110: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
3111: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
3112: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
3113: --
3114: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
3115: --
3116: cursor csr_payroll_year (p_payroll_id NUMBER,
3117: p_start_year DATE,
3118: p_end_year DATE) IS

Line 3274: hr_soft_coding_keyflex flex

3270: from per_all_people_f pap,
3271: per_all_assignments_f paaf,
3272: per_assignment_status_types past,
3273: pay_all_payrolls_f papf,
3274: hr_soft_coding_keyflex flex
3275: where pap.person_id between stperson and endperson
3276: and pap.person_id = paaf.person_id
3277: and paaf.assignment_type = 'E'
3278: and paaf.assignment_status_type_id = past.assignment_status_type_id