APPS.PAY_CORE_FF_UDFS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 3358: pay_assignment_actions paa_run

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')
3362: AND ((nvl(paa_run.run_type_id, ppa_run.run_type_id) is null and

Line 3372: pay_assignment_actions paa_rev,

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
3376: AND ppa_rev.payroll_action_id = paa_rev.payroll_action_id

Line 3385: pay_assignment_actions paa_run

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')
3389: AND ((nvl(paa_run.run_type_id, ppa_run.run_type_id) is null and

Line 3399: pay_assignment_actions paa_rev,

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
3403: AND ppa_rev.payroll_action_id = paa_rev.payroll_action_id