DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PER_CONTRACTS_F

Line 457: FROM per_contracts_f cont

453: BEGIN
454: BEGIN
455: SELECT cont.type
456: INTO l_contract
457: FROM per_contracts_f cont
458: ,per_all_assignments_f asg
459: WHERE asg.assignment_id = p_assignment_id
460: AND asg.contract_id = cont.contract_id
461: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 514: FROM per_contracts_f cont

510: BEGIN
511:
512: SELECT cont.type, fnd_date.canonical_to_date(cont.ctr_information2)
513: INTO l_contract, l_expiry_date
514: FROM per_contracts_f cont
515: ,per_all_assignments_f asg
516: WHERE asg.assignment_id = p_assignment_id
517: AND asg.contract_id = cont.contract_id
518: AND p_date_earned BETWEEN asg.effective_start_date AND asg.effective_end_date