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

Line 256: hr_soft_coding_keyflex flex,

252: -- tax_district_reference specified delete all rows within the business group
253: delete from pay_gb_year_end_values v where exists (
254: select '1' from pay_gb_year_end_assignments ye_asg,
255: pay_payrolls_f p,
256: hr_soft_coding_keyflex flex,
257: hr_organization_information org
258: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
259: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
260: and org.org_information1 = flex.segment1

Line 284: hr_soft_coding_keyflex flex, hr_organization_information org

280: -- delete all the rows for this tax_district_reference else if no
281: -- tax_district_reference specified delete all rows within the business group
282: delete from pay_gb_year_end_assignments ye_asg where exists (
283: select '1' from pay_payrolls_f p,
284: hr_soft_coding_keyflex flex, hr_organization_information org
285: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
286: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
287: and org.org_information1 = flex.segment1
288: and p.business_group_id = p_business_group_id

Line 309: hr_soft_coding_keyflex flex, hr_organization_information org

305: -- delete all the rows for this tax_district_reference else if no
306: -- tax_district_reference specified delete all rows within the business group
307: delete from pay_gb_year_end_payrolls ye_roll
308: where exists ( select '1' from pay_payrolls_f p,
309: hr_soft_coding_keyflex flex, hr_organization_information org
310: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
311: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
312: and org.org_information1 = flex.segment1
313: and p.business_group_id = p_business_group_id

Line 525: ,hr_soft_coding_keyflex FLEX

521: ( select nvl(max(ASS.effective_start_date),
522: fnd_date.canonical_to_date('01-01-0001'))
523: from per_assignments_f ASS
524: ,pay_payrolls_f NROLL
525: ,hr_soft_coding_keyflex FLEX
526: ,per_assignments_f PASS /* previous assignment */
527: ,pay_payrolls_f PROLL
528: ,hr_soft_coding_keyflex PFLEX
529: where ASS.assignment_id = BAL_ASSACT.assignment_id

Line 528: ,hr_soft_coding_keyflex PFLEX

524: ,pay_payrolls_f NROLL
525: ,hr_soft_coding_keyflex FLEX
526: ,per_assignments_f PASS /* previous assignment */
527: ,pay_payrolls_f PROLL
528: ,hr_soft_coding_keyflex PFLEX
529: where ASS.assignment_id = BAL_ASSACT.assignment_id
530: and NROLL.payroll_id = ASS.payroll_id
531: and ASS.effective_start_date between
532: NROLL.effective_start_date and NROLL.effective_end_date

Line 837: hr_soft_coding_keyflex flex, hr_organization_information org

833: flex.segment11 * 100 SMP_RECOVERED,
834: flex.segment12 * 100 SMP_COMPENSATION,
835: flex.segment13 * 100 SSP_RECOVERED
836: from pay_payrolls_f p,
837: hr_soft_coding_keyflex flex, hr_organization_information org
838: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
839: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
840: and org.org_information1 = flex.segment1
841: and p.business_group_id = p_business_group_id

Line 973: ,hr_soft_coding_keyflex FLEX

969: ass.location_id,
970: ass.people_group_id
971: from per_assignments_f ASS
972: ,pay_payrolls_f NROLL
973: ,hr_soft_coding_keyflex FLEX
974: ,per_assignments_f PASS
975: ,pay_payrolls_f PROLL
976: ,hr_soft_coding_keyflex PFLEX
977: ,pay_gb_year_end_payrolls ye_roll

Line 976: ,hr_soft_coding_keyflex PFLEX

972: ,pay_payrolls_f NROLL
973: ,hr_soft_coding_keyflex FLEX
974: ,per_assignments_f PASS
975: ,pay_payrolls_f PROLL
976: ,hr_soft_coding_keyflex PFLEX
977: ,pay_gb_year_end_payrolls ye_roll
978: where NROLL.payroll_id = ASS.payroll_id
979: and ye_roll.payroll_id = PASS.payroll_id
980: and ASS.effective_start_date between

Line 1032: ,hr_soft_coding_keyflex FLEX

1028: update pay_gb_year_end_assignments ye_asg set ( effective_start_date ) =
1029: ( select max(ASS.effective_start_date)
1030: from per_assignments_f ASS
1031: ,pay_payrolls_f NROLL
1032: ,hr_soft_coding_keyflex FLEX
1033: ,per_assignments_f PASS
1034: ,pay_payrolls_f PROLL
1035: ,hr_soft_coding_keyflex PFLEX
1036: ,pay_gb_year_end_payrolls ye_roll

Line 1035: ,hr_soft_coding_keyflex PFLEX

1031: ,pay_payrolls_f NROLL
1032: ,hr_soft_coding_keyflex FLEX
1033: ,per_assignments_f PASS
1034: ,pay_payrolls_f PROLL
1035: ,hr_soft_coding_keyflex PFLEX
1036: ,pay_gb_year_end_payrolls ye_roll
1037: where ass.assignment_id = ye_asg.assignment_id
1038: and ass.effective_start_date < ye_asg.effective_end_date
1039: and NROLL.payroll_id = ASS.payroll_id