DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 304: (p_organization_id in per_all_assignments_f.organization_id%TYPE

300: -- vkodedal added on 19-feb-2008 to fix multiple component upload issue
301: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
302: );
303: procedure is_salary_in_range_int
304: (p_organization_id in per_all_assignments_f.organization_id%TYPE
305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

Line 305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

301: ,p_multiple_components in per_pay_proposals.multiple_components%TYPE
302: );
303: procedure is_salary_in_range_int
304: (p_organization_id in per_all_assignments_f.organization_id%TYPE
305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE

Line 306: ,p_position_id in per_all_assignments_f.position_id%TYPE

302: );
303: procedure is_salary_in_range_int
304: (p_organization_id in per_all_assignments_f.organization_id%TYPE
305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

Line 307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

303: procedure is_salary_in_range_int
304: (p_organization_id in per_all_assignments_f.organization_id%TYPE
305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
311: ,p_change_date in per_pay_proposals.change_date%TYPE

Line 308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

304: (p_organization_id in per_all_assignments_f.organization_id%TYPE
305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
311: ,p_change_date in per_pay_proposals.change_date%TYPE
312: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 309: ,p_frequency in per_all_assignments_f.frequency%TYPE

305: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
306: ,p_position_id in per_all_assignments_f.position_id%TYPE
307: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
308: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
309: ,p_frequency in per_all_assignments_f.frequency%TYPE
310: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
311: ,p_change_date in per_pay_proposals.change_date%TYPE
312: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
313: ,p_prop_salary_link_warning out nocopy boolean

Line 317: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

313: ,p_prop_salary_link_warning out nocopy boolean
314: ,p_prop_salary_ele_warning out nocopy boolean
315: ,p_prop_salary_grade_warning out nocopy boolean
316: --vkodedal 03-Jun-2009 8452388
317: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
318: );
319:
320: ---vkodedal 8587143 10-Jun-2009
321: ---over load the same to make sure old core hr forms won't fail

Line 325: (p_organization_id in per_all_assignments_f.organization_id%TYPE

321: ---over load the same to make sure old core hr forms won't fail
322: ---PERWSQHM.fmb has a reference to this procedure and assignment id will be null
323: ---when inserting
324: procedure is_salary_in_range_int
325: (p_organization_id in per_all_assignments_f.organization_id%TYPE
326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

Line 326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

322: ---PERWSQHM.fmb has a reference to this procedure and assignment id will be null
323: ---when inserting
324: procedure is_salary_in_range_int
325: (p_organization_id in per_all_assignments_f.organization_id%TYPE
326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE

Line 327: ,p_position_id in per_all_assignments_f.position_id%TYPE

323: ---when inserting
324: procedure is_salary_in_range_int
325: (p_organization_id in per_all_assignments_f.organization_id%TYPE
326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

Line 328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

324: procedure is_salary_in_range_int
325: (p_organization_id in per_all_assignments_f.organization_id%TYPE
326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
332: ,p_change_date in per_pay_proposals.change_date%TYPE

Line 329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE

325: (p_organization_id in per_all_assignments_f.organization_id%TYPE
326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
332: ,p_change_date in per_pay_proposals.change_date%TYPE
333: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE

Line 330: ,p_frequency in per_all_assignments_f.frequency%TYPE

326: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
327: ,p_position_id in per_all_assignments_f.position_id%TYPE
328: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
329: ,p_normal_hours in per_all_assignments_f.normal_hours%TYPE
330: ,p_frequency in per_all_assignments_f.frequency%TYPE
331: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
332: ,p_change_date in per_pay_proposals.change_date%TYPE
333: ,p_proposed_salary_n in per_pay_proposals.proposed_salary_n%TYPE
334: ,p_prop_salary_link_warning out nocopy boolean