APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1042: FROM PER_ASSIGNMENT_EXTRA_INFO

1038: rg_csr_assignments_dtl csr_assignments_dtl%rowtype;
1039:
1040: CURSOR cur_get_hol_pay_perc(p_effective_date DATE, p_asg_id NUMBER) IS
1041: SELECT fnd_number.canonical_to_number(AEI_INFORMATION3)
1042: FROM PER_ASSIGNMENT_EXTRA_INFO
1043: WHERE
1044: ASSIGNMENT_ID = p_asg_id
1045: AND INFORMATION_TYPE = 'DK_EHOLC_HPAY_RATE'
1046: AND p_effective_date between fnd_date.canonical_to_date(AEI_INFORMATION1)

Line 1406: FROM per_assignment_extra_info

1402:
1403: --Bug 8522052 record 6003
1404: CURSOR csr_asg_extra_info (p_assgt_id NUMBER) IS
1405: SELECT *
1406: FROM per_assignment_extra_info
1407: WHERE information_type = 'DK_EINCOME_INFO'
1408: AND assignment_id = p_assgt_id;
1409:
1410: rg_csr_asg_extra_info csr_asg_extra_info%ROWTYPE;