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 3357: FROM pay_payroll_actions ppa_run,

3353:
3354: CURSOR csr_fpprocd_min_dtearned(p_atd DATE
3355: ,p_assignment_id NUMBER) IS
3356: SELECT min(ppa_run.date_earned)
3357: FROM pay_payroll_actions ppa_run,
3358: pay_assignment_actions paa_run
3359: WHERE ppa_run.date_earned >= p_atd
3360: AND ppa_run.action_status = 'C'
3361: AND ppa_run.action_type in ('Q','R','B','I')

Line 3371: FROM pay_payroll_actions ppa_rev,

3367: AND paa_run.action_status = 'C'
3368: AND paa_run.assignment_id = p_assignment_id
3369: AND NOT EXISTS (
3370: SELECT 1
3371: FROM pay_payroll_actions ppa_rev,
3372: pay_assignment_actions paa_rev,
3373: pay_action_interlocks pai
3374: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3375: AND pai.locking_action_id = paa_rev.assignment_action_id

Line 3384: FROM pay_payroll_actions ppa_run,

3380:
3381: CURSOR csr_lspprocd_min_dtearned(p_lspd DATE
3382: ,p_assignment_id NUMBER) IS
3383: SELECT min(ppa_run.date_earned)
3384: FROM pay_payroll_actions ppa_run,
3385: pay_assignment_actions paa_run
3386: WHERE ppa_run.date_earned >= p_lspd
3387: AND ppa_run.action_status = 'C'
3388: AND ppa_run.action_type in ('Q','R','B','I')

Line 3398: FROM pay_payroll_actions ppa_rev,

3394: AND paa_run.action_status = 'C'
3395: AND paa_run.assignment_id = p_assignment_id
3396: AND NOT EXISTS (
3397: SELECT 1
3398: FROM pay_payroll_actions ppa_rev,
3399: pay_assignment_actions paa_rev,
3400: pay_action_interlocks pai
3401: WHERE pai.locked_Action_id = paa_run.assignment_action_id
3402: AND pai.locking_action_id = paa_rev.assignment_action_id