[Home] [Help]
1943:
1944: CURSOR c_ass_act IS
1945: SELECT max(paa.assignment_action_id)
1946: FROM pay_assignment_actions paa
1947: ,pay_payroll_actions ppa
1948: WHERE paa.assignment_id = p_assignment_id
1949: AND ppa.action_status = 'C'
1950: AND ppa.action_type IN ('Q','R')
1951: AND paa.action_status = 'C'
2059: function get_abp_pension_salary
2060: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
2061: ,p_date_earned in date
2062: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2063: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
2064: ,p_period_start_date in date
2065: ,p_period_end_date in date
2066: ,p_scale_salary in number
2067: ,p_scale_salary_h in number
3129: function get_pension_salary
3130: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
3131: ,p_date_earned in date
3132: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3133: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3134: ,p_salary_balance_name in varchar2
3135: ,p_payroll_period in varchar2
3136: ,p_salary_balance_value out nocopy number
3137: ,p_error_message out nocopy varchar2
3203: --,c_payroll_id IN NUMBER
3204: ,c_period_start IN DATE
3205: ,c_period_end IN DATE) IS
3206: SELECT paa.assignment_action_id
3207: FROM pay_payroll_actions ppa
3208: ,pay_assignment_actions paa
3209: where ppa.payroll_action_id = paa.payroll_action_id
3210: and ppa.time_period_id = c_time_period_id
3211: --and payroll_id = c_payroll_id
4598: CURSOR c_get_asg_act_id (c_time_period_id IN NUMBER
4599: ,c_period_start IN DATE
4600: ,c_period_end IN DATE) IS
4601: SELECT paa.assignment_action_id
4602: FROM pay_payroll_actions ppa
4603: ,pay_assignment_actions paa
4604: WHERE ppa.payroll_action_id = paa.payroll_action_id
4605: AND ppa.time_period_id = c_time_period_id
4606: AND paa.assignment_id = p_assignment_id