APPS.PAY_GB_RTI dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 508: FROM PER_ASSIGNMENT_EXTRA_INFO

504: from dual;
505:
506: cursor csr_get_irregular_details is
507: SELECT AEI_INFORMATION3
508: FROM PER_ASSIGNMENT_EXTRA_INFO
509: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
510: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
511: AND assignment_id = p_person_rec.assignment_id;
512:

Line 1487: FROM per_assignment_extra_info

1483: procedure set_new_starter_rti_sent(p_asg_id number) is
1484:
1485: cursor csr_asg_extra_info is
1486: select ASSIGNMENT_EXTRA_INFO_ID, AEI_INFORMATION8,object_version_number
1487: FROM per_assignment_extra_info
1488: WHERE assignment_id = p_asg_id
1489: AND information_type = 'GB_RTI_ASG_DETAILS';
1490:
1491: l_asg_extra_info_id number;