APPS.PAY_FR_MIGRATE_TIME_ANALYSIS dependencies on PER_CONTRACTS_F

Line 32: from per_contracts_f

28: Order by asg.effective_start_date;
29:
30: Cursor csr_get_all_contr(c_person_id number) is
31: Select distinct contract_id
32: from per_contracts_f
33: where business_group_id = p_business_group_id
34: and person_id = c_person_id ;
35:
36: Cursor csr_all_contr_date(c_contract_id number,

Line 47: from per_contracts_f

43: effective_start_date,
44: effective_end_date,
45: person_id,
46: object_version_number
47: from per_contracts_f
48: where business_group_id = p_business_group_id
49: and contract_id = c_contract_id
50: and effective_start_date
51: between c_previous_start_date and c_asg_start_date