APPS.PAY_GB_RTI_EAS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 410: FROM PER_ASSIGNMENT_EXTRA_INFO

406:
407: /* EAS 2013 Changes */
408: cursor csr_get_extra_asg_details is
409: SELECT AEI_INFORMATION5
410: FROM PER_ASSIGNMENT_EXTRA_INFO
411: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
412: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
413: AND assignment_id = p_assignment_id;
414:

Line 456: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

452: - Formula Function
453: **/
454: IF l_source_name = 'Assignment Developer DF' THEN
455: l_sqlstr := 'select ' || l_column_name ||
456: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
457: begin
458:
459: hr_utility.trace('string '||l_sqlstr);
460: EXECUTE immediate l_sqlstr INTO l_expat_indicator USING p_assignment_id,l_context_name;

Line 553: FROM PER_ASSIGNMENT_EXTRA_INFO

549:
550: /* EAS 2013 Changes */
551: cursor csr_get_extra_asg_details is
552: SELECT AEI_INFORMATION6
553: FROM PER_ASSIGNMENT_EXTRA_INFO
554: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
555: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
556: AND assignment_id = p_assignment_id;
557:

Line 599: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

595: - Formula Function
596: **/
597: IF l_source_name = 'Assignment Developer DF' THEN
598: l_sqlstr := 'select ' || l_column_name ||
599: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
600: begin
601:
602: hr_utility.trace('string '||l_sqlstr);
603: EXECUTE immediate l_sqlstr INTO l_occ_pension_indicator USING p_assignment_id,l_context_name;

Line 695: FROM PER_ASSIGNMENT_EXTRA_INFO

691:
692: /* EAS 2013 Changes */
693: cursor csr_get_extra_asg_details is
694: SELECT AEI_INFORMATION7
695: FROM PER_ASSIGNMENT_EXTRA_INFO
696: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
697: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
698: AND assignment_id = p_assignment_id;
699:

Line 741: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';

737: - Formula Function
738: **/
739: IF l_source_name = 'Assignment Developer DF' THEN
740: l_sqlstr := 'select ' || l_column_name ||
741: ' from per_assignment_extra_info where assignment_id = :assignment_id and AEI_INFORMATION_CATEGORY = :l_context_name';
742: begin
743:
744: hr_utility.trace('string '||l_sqlstr);
745: EXECUTE immediate l_sqlstr INTO l_pay_non_indiv_ind USING p_assignment_id,l_context_name;

Line 890: FROM PER_ASSIGNMENT_EXTRA_INFO

886: from dual;
887:
888: cursor csr_get_irregular_details is
889: SELECT AEI_INFORMATION3
890: FROM PER_ASSIGNMENT_EXTRA_INFO
891: WHERE INFORMATION_TYPE = 'GB_PAY_RTI'
892: AND AEI_INFORMATION_CATEGORY = 'GB_PAY_RTI'
893: AND assignment_id = p_person_rec.assignment_id;
894:

Line 1980: FROM per_assignment_extra_info

1976:
1977:
1978: cursor csr_asg_extra_info is
1979: select ASSIGNMENT_EXTRA_INFO_ID, AEI_INFORMATION8,object_version_number
1980: FROM per_assignment_extra_info
1981: WHERE assignment_id = p_asg_id
1982: AND information_type = 'GB_RTI_ASG_DETAILS';
1983:
1984: l_asg_extra_info_id number;