APPS.PAY_CN_EXT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

2580: l_date_earned DATE;
2581: l_prev_month DATE;
2582: l_no_of_runs NUMBER;
2583: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
2585:
2586: l_phf_si_type VARCHAR2(50);
2587: l_start_date DATE;
2588: l_end_date DATE;

Line 2626: FROM pay_assignment_actions paa

2622: ,p_end_date IN DATE)
2623: IS
2624: --
2625: SELECT max(paa.assignment_action_id)
2626: FROM pay_assignment_actions paa
2627: , pay_payroll_actions ppa
2628: , per_all_assignments_f paf
2629: WHERE paa.payroll_action_id = ppa.payroll_action_id
2630: AND paf.assignment_id = p_assignment_id

Line 2650: FROM pay_assignment_actions paa

2646: CURSOR csr_date_earned(p_assg_act_id IN NUMBER)
2647: IS
2648: --
2649: SELECT ppa.date_earned
2650: FROM pay_assignment_actions paa
2651: , pay_payroll_actions ppa
2652: WHERE paa.assignment_action_id = p_assg_act_id
2653: AND paa.payroll_action_id = ppa.payroll_action_id;
2654:

Line 3073: FROM pay_assignment_actions paa

3069: CURSOR csr_assg_act(p_start_date IN DATE
3070: ,p_end_date IN DATE)
3071: IS
3072: SELECT max(paa.assignment_action_id)
3073: FROM pay_assignment_actions paa
3074: , pay_payroll_actions ppa
3075: , per_all_assignments_f paf
3076: WHERE paa.payroll_action_id = ppa.payroll_action_id
3077: AND paf.assignment_id = p_assignment_id

Line 3090: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

3086: AND ppa.business_group_id = p_business_group_id;
3087: --
3088: -- Bug 3603564 changes end
3089: --
3090: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3091:
3092: BEGIN
3093:
3094: l_proc_name := 'pay_cn_ext.get_assignment_action';