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.PSP_ENC_PRE_PROCESS dependencies on PER_ASSIGNMENTS_F

Line 532: per_assignments_f paf

528: NVL(psl.poeta_start_date,TO_DATE('01-01-1800', 'DD-MM-YYYY')) poeta_start_date,
529: NVL(psl.poeta_end_date,TO_DATE('31-12-4712', 'DD-MM-YYYY')) poeta_start_date
530: FROM psp_schedule_hierarchy psh,
531: psp_schedule_lines psl ,
532: per_assignments_f paf
533: WHERE psl.business_group_id = p_business_group_id
534: AND psl.set_of_books_id = p_set_of_books_id
535: AND psl.schedule_hierarchy_id = psh.schedule_hierarchy_id
536: AND psl.schedule_end_date >= p_max_pay_date

Line 1723: per_assignments_f paf

1719: CURSOR org_ds_insert_cur (p_reference_id NUMBER) IS
1720: SELECT DISTINCT pelh.assignment_id,
1721: pelh.payroll_id
1722: FROM psp_enc_lines_history pelh,
1723: per_assignments_f paf
1724: WHERE pelh.schedule_line_id IS NULL
1725: AND pelh.element_account_id IS NULL
1726: AND pelh.change_flag = 'N'
1727: AND pelh.assignment_id = paf.assignment_id

Line 1738: per_assignments_f paf

1734: CURSOR org_da_insert_cur (p_reference_id NUMBER) IS
1735: SELECT DISTINCT pelh.assignment_id,
1736: pelh.payroll_id
1737: FROM psp_enc_lines_history pelh,
1738: per_assignments_f paf
1739: WHERE pelh.suspense_org_account_id IS NOT NULL
1740: AND pelh.suspense_reason_code IN ('LDM_NO_CI_FOUND', 'LDM_BAL_NOT_100_PERCENT')
1741: AND paf.organization_id = p_reference_id
1742: AND pelh.assignment_id = paf.assignment_id

Line 1750: per_assignments_f paf,

1746: CURSOR org_sa_insert_cur (p_reference_id NUMBER) IS
1747: SELECT DISTINCT pelh.assignment_id,
1748: pelh.payroll_id
1749: FROM psp_enc_lines_history pelh,
1750: per_assignments_f paf,
1751: psp_organization_accounts poa
1752: WHERE pelh.suspense_org_account_id = poa.organization_account_id
1753: AND poa.organization_id = l_generic_suspense
1754: AND pelh.change_flag = 'N'

Line 1789: per_assignments_f paf

1785: FROM psp_enc_lines_history pelh,
1786: psp_default_labor_schedules pdls,
1787: psp_schedule_lines psl,
1788: psp_element_type_accounts peta,
1789: per_assignments_f paf
1790: -- psp_enc_end_dates peed Commented for bug fix 3426871
1791: --WHERE peed.enc_end_date_id = p_reference_id Commented for bug fix 3426871
1792: WHERE pelh.assignment_id = paf.assignment_id
1793: AND pelh.change_flag = 'N'