APPS.PER_CTC_DEL dependencies on PER_CONTRACTS_F

Line 70: delete from per_contracts_f

66: --
67: -- Delete the where the effective start date is equal
68: -- to the validation end date.
69: --
70: delete from per_contracts_f
71: where contract_id = p_rec.contract_id
72: and effective_start_date = p_validation_start_date;
73: --
74: Else

Line 80: delete from per_contracts_f

76: --
77: -- Delete the row(s) where the effective start date is greater than
78: -- or equal to the validation start date.
79: --
80: delete from per_contracts_f
81: where contract_id = p_rec.contract_id
82: and effective_start_date >= p_validation_start_date;
83: --
84: End If;

Line 378: (p_module_name => 'per_contracts_f'

374: --
375: when hr_api.cannot_find_prog_unit then
376: --
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'per_contracts_f'
379: ,p_hook_type => 'AD');
380: --
381: end;
382: --

Line 509: p_contract_id in per_contracts_f.contract_id%TYPE,

505: -- date changes.
506: --
507: procedure delete_row
508: (
509: p_contract_id in per_contracts_f.contract_id%TYPE,
510: p_effective_date in date,
511: p_object_version_number in per_contracts_f.object_version_number%TYPE
512: ) is
513: --

Line 511: p_object_version_number in per_contracts_f.object_version_number%TYPE

507: procedure delete_row
508: (
509: p_contract_id in per_contracts_f.contract_id%TYPE,
510: p_effective_date in date,
511: p_object_version_number in per_contracts_f.object_version_number%TYPE
512: ) is
513: --
514: l_proc varchar2(72) := g_package||'delete_row';
515: --

Line 548: delete from per_contracts_f

544: );
545: --
546: -- delete row
547: --
548: delete from per_contracts_f
549: where contract_id = p_contract_id and
550: p_effective_date between effective_start_date
551: and effective_end_date;
552: --