DBA Data[Home] [Help]

APPS.PER_RO_ASSIGNMENT_VAL dependencies on PER_CONTRACTS_F

Line 64: l_contract_start_date per_contracts_f.effective_start_date%type;

60: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
61:
62: l_proc VARCHAR2(60);
63: l_exist varchar2(1);
64: l_contract_start_date per_contracts_f.effective_start_date%type;
65: l_assignment_start_date per_all_assignments_f.effective_start_date%type := p_effective_date;
66: l_contract_signed_date PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION1%type;
67:
68: BEGIN