APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 24: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

20: --
21: function get_pension_type_details
22: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
23: ,p_date_earned in date
24: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
25: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
26: ,p_legislation_code in pqp_pension_types_f.legislation_code%TYPE
27: ,p_column_name in varchar2
28: ,p_column_value out nocopy varchar2

Line 40: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

36: --
37: function prorate_amount
38: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
39: ,p_date_earned in date
40: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
41: ,p_amount in number
42: ,p_payroll_period in varchar2
43: ,p_work_pattern in varchar2
44: ,p_conversion_rule in varchar2

Line 71: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

67:
68: function get_abp_pension_salary
69: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
70: ,p_date_earned in date
71: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
72: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
73: ,p_period_start_date in date
74: ,p_period_end_date in date
75: ,p_scale_salary in number

Line 103: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

99: --
100: function get_pension_salary
101: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
102: ,p_date_earned in date
103: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
104: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
105: ,p_salary_balance_name in varchar2
106: ,p_payroll_period in varchar2
107: ,p_salary_balance_value out nocopy number

Line 161: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

157: -- ------------------------------------------------------------------
158:
159: FUNCTION get_bonus
160: ( p_date_earned in date
161: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
162: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
163: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
164: ,p_pay_period_salary in number
165: ,p_pay_period in varchar2

Line 207: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

203: --
204: function get_abp_entry_value
205: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
206: ,p_date_earned in date
207: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
208: ,p_element_type_id in number
209: ,p_input_value_name in varchar2
210: ) return NUMBER;
211:

Line 219: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

215: --
216: function get_avg_part_time_perc
217: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
218: ,p_date_earned in date
219: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
220: ,p_assignment_action_id IN NUMBER
221: ,p_period_start_date in DATE
222: ,p_period_end_date in DATE
223: ,p_avg_part_time_perc OUT NOCOPY NUMBER

Line 260: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

256: --
257: FUNCTION get_pay_period_age
258: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
259: ,p_date_earned IN DATE
260: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
261: ,p_period_start_date IN DATE
262: ) RETURN NUMBER;
263:
264: --

Line 271: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

267: -- ----------------------------------------------------------------------------
268: --
269: FUNCTION get_bal_val
270: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
271: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,p_effective_date IN DATE
273: ,p_balance_name IN VARCHAR2
274: ,p_dimension_name IN VARCHAR2)
275: RETURN NUMBER;