APPS.PQP_NL_ABP_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 25: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

21: --
22: function abp_proration
23: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
24: ,p_date_earned in date
25: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
26: ,p_amount in number
27: ,p_payroll_period in varchar2
28: ,p_work_pattern in varchar2
29: ,p_conversion_rule in varchar2

Line 164: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

160: -- ------------------------------------------------------------------------
161: --
162:
163: FUNCTION get_abp_contribution
164: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
165: ,p_date_earned in date
166: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
167: ,p_payroll_action_id IN NUMBER
168: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE

Line 185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

181: -- ------------------------------------------------------------------------
182: --
183:
184: FUNCTION get_participation_date
185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
186: ,p_date_earned in date
187: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
188: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
189: ,p_start_date out NOCOPY date

Line 200: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

196: -- ------------------------------------------------------------------------
197: --
198:
199: FUNCTION get_assignment_attribute
200: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
201: ,p_date_earned in date
202: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
203: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
204: ,p_attrib_name in varchar2

Line 218: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

214: -- ------------------------------------------------------------------------
215: --
216:
217: PROCEDURE get_participation_org
218: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
219: ,p_date_earned in date
220: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
221: ,p_asg_or_org out NOCOPY number
222: ,p_org_id out NOCOPY number

Line 259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

255: -- ------------------------------------------------------------------------
256: --
257:
258: FUNCTION get_absence_adjustment
259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
260: ,p_date_earned in date
261: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
262: ,p_dedn_amt in number
263: ,p_adjust_amt out NOCOPY number

Line 275: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

271: -- ------------------------------------------------------------------------
272: --
273:
274: FUNCTION get_proration_factor
275: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
276: ,p_date_earned in date
277: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
278: ,p_proration_factor out NOCOPY number
279: ,p_error_message out NOCOPY varchar2

Line 290: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

286: --
287: FUNCTION get_abp_calc_eff_dt
288: (p_date_earned IN DATE
289: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
290: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
291: ,p_effective_date OUT NOCOPY DATE
292: )
293: RETURN NUMBER;
294: --

Line 302: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

298: --
299: FUNCTION get_proration_flag
300: (p_date_earned IN DATE
301: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
302: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
303: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
304: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
305: ,p_start_date IN DATE
306: ,p_end_date IN DATE

Line 303: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE

299: FUNCTION get_proration_flag
300: (p_date_earned IN DATE
301: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
302: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
303: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
304: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
305: ,p_start_date IN DATE
306: ,p_end_date IN DATE
307: )

Line 317: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

313: --
314: FUNCTION get_eoy_bonus_percentage
315: (p_date_earned IN DATE
316: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
317: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,p_eoy_bonus_percentage OUT NOCOPY NUMBER
319: )
320: RETURN NUMBER;
321: