APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 2128: FROM pay_payroll_actions

2124: AS
2125:
2126: CURSOR c_date_paid IS
2127: SELECT effective_date
2128: FROM pay_payroll_actions
2129: WHERE payroll_action_id= p_payroll_action_id;
2130:
2131: l_date_paid c_date_paid%ROWTYPE;
2132: BEGIN

Line 2465: FROM pay_payroll_actions ppa

2461:
2462: CURSOR c_get_payroll_date
2463: IS
2464: SELECT ppa.effective_date
2465: FROM pay_payroll_actions ppa
2466: WHERE ppa.payroll_action_id = p_payroll_action_id
2467: AND ppa.business_group_id = p_business_group_id;
2468:
2469: CURSOR c_get_end_date (cp_date DATE)

Line 2664: pay_payroll_actions PAY_ACTION,

2660: AND (screen_entry_value) > FND_DATE.date_to_canonical (cp_to_date)
2661: AND EXISTS (select 'Y'
2662: from pay_run_results RESULT,
2663: pay_assignment_actions ASGT_ACTION,
2664: pay_payroll_actions PAY_ACTION,
2665: per_time_periods PERIOD
2666: where result.source_id = pev.element_entry_id --nvl (p_original_entry_id, p_element_entry_id)
2667: and result.status <> 'U'
2668: and result.source_type = 'E'

Line 2681: FROM pay_payroll_actions ppa

2677:
2678: CURSOR c_get_payroll_act_dt (cp_payroll_action_id NUMBER)
2679: IS
2680: SELECT ppa.effective_date
2681: FROM pay_payroll_actions ppa
2682: WHERE payroll_action_id=cp_payroll_action_id;
2683:
2684:
2685: l_eff_dt DATE;