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_CORE_FF_UDFS dependencies on PAY_PAYROLL_ACTIONS

Line 3776: FROM pay_payroll_actions ppa_run,

3772:
3773: CURSOR csr_fpprocd_min_dtearned(p_atd DATE
3774: ,p_assignment_id NUMBER) IS
3775: SELECT min(ppa_run.date_earned)
3776: FROM pay_payroll_actions ppa_run,
3777: pay_assignment_actions paa_run
3778: WHERE ppa_run.date_earned >= p_atd
3779: AND ppa_run.action_status = 'C'
3780: AND ppa_run.action_type in ('Q','R','B','I')

Line 3790: FROM pay_payroll_actions ppa_rev,

3786: AND paa_run.action_status = 'C'
3787: AND paa_run.assignment_id = p_assignment_id
3788: AND NOT EXISTS (
3789: SELECT 1
3790: FROM pay_payroll_actions ppa_rev,
3791: pay_assignment_actions paa_rev,
3792: pay_action_interlocks pai
3793: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3794: AND pai.locking_action_id = paa_rev.assignment_action_id

Line 3803: FROM pay_payroll_actions ppa_run,

3799:
3800: CURSOR csr_lspprocd_min_dtearned(p_lspd DATE
3801: ,p_assignment_id NUMBER) IS
3802: SELECT min(ppa_run.date_earned)
3803: FROM pay_payroll_actions ppa_run,
3804: pay_assignment_actions paa_run
3805: WHERE ppa_run.date_earned >= p_lspd
3806: AND ppa_run.action_status = 'C'
3807: AND ppa_run.action_type in ('Q','R','B','I')

Line 3817: FROM pay_payroll_actions ppa_rev,

3813: AND paa_run.action_status = 'C'
3814: AND paa_run.assignment_id = p_assignment_id
3815: AND NOT EXISTS (
3816: SELECT 1
3817: FROM pay_payroll_actions ppa_rev,
3818: pay_assignment_actions paa_rev,
3819: pay_action_interlocks pai
3820: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3821: AND pai.locking_action_id = paa_rev.assignment_action_id