APPS.PAY_PPM_DEL dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 71: delete from pay_personal_payment_methods_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from pay_personal_payment_methods_f
72: where personal_payment_method_id = p_rec.personal_payment_method_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

Line 83: delete from pay_personal_payment_methods_f

79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --
83: delete from pay_personal_payment_methods_f
84: where personal_payment_method_id = p_rec.personal_payment_method_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

Line 242: /*Added DISTINCT as comment_id is not date-tracked in PAY_PERSONAL_PAYMENT_METHODS_F.

238: --
239: -- Cursor C_Sel1 select comments to be deleted
240: --
241: Cursor C_Sel1 is
242: /*Added DISTINCT as comment_id is not date-tracked in PAY_PERSONAL_PAYMENT_METHODS_F.
243: Absence of DISTINCT causing locking contention due to locking same row of
244: HR_COMMENTS for multiple times in case of ZAP operation.Bug#9358129.*/
245: select DISTINCT t1.comment_id
246: from pay_personal_payment_methods_f t1

Line 246: from pay_personal_payment_methods_f t1

242: /*Added DISTINCT as comment_id is not date-tracked in PAY_PERSONAL_PAYMENT_METHODS_F.
243: Absence of DISTINCT causing locking contention due to locking same row of
244: HR_COMMENTS for multiple times in case of ZAP operation.Bug#9358129.*/
245: select DISTINCT t1.comment_id
246: from pay_personal_payment_methods_f t1
247: where t1.comment_id is not null
248: and t1.personal_payment_method_id = p_rec.personal_payment_method_id
249: and t1.effective_start_date <= p_validation_end_date
250: and t1.effective_end_date >= p_validation_start_date

Line 253: from pay_personal_payment_methods_f t2

249: and t1.effective_start_date <= p_validation_end_date
250: and t1.effective_end_date >= p_validation_start_date
251: and not exists
252: (select 1
253: from pay_personal_payment_methods_f t2
254: where t2.comment_id = t1.comment_id
255: and t2.personal_payment_method_id = t1.personal_payment_method_id
256:
257: and (t2.effective_start_date > p_validation_end_date

Line 472: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'

468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'
473: ,p_hook_type => 'AD'
474: );
475: end;
476: -- End of API User Hook for post_delete.