DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PER_CONTRACTS_F

Line 419: FROM per_contracts_f cont

415: BEGIN
416: BEGIN
417: SELECT cont.type
418: INTO l_contract
419: FROM per_contracts_f cont
420: ,per_all_assignments_f asg
421: WHERE asg.assignment_id = p_assignment_id
422: AND asg.contract_id = cont.contract_id
423: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 448: FROM per_contracts_f cont

444: BEGIN
445:
446: SELECT cont.type, fnd_date.canonical_to_date(cont.ctr_information2)
447: INTO l_contract, l_expiry_date
448: FROM per_contracts_f cont
449: ,per_all_assignments_f asg
450: WHERE asg.assignment_id = p_assignment_id
451: AND asg.contract_id = cont.contract_id
452: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date