APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_PGM_EXTRA_INFO

Line 3244: FROM ben_pgm_extra_info

3240: l_ovn number;
3241: l_old_flag varchar2(1) := 'Y';
3242: cursor c1 is
3243: SELECT pgm_extra_info_id,pgi_information1,pgi_information2,pgi_information3,pgi_information4
3244: FROM ben_pgm_extra_info
3245: where information_type ='PQH_GSP_EXTRA_INFO'
3246: and pgm_id = p_pgm_id;
3247: begin
3248: hr_utility.set_location('pgm id is'||p_pgm_id,10);

Line 3262: ,p_table_name => 'BEN_PGM_EXTRA_INFO'

3258: ,p_information12 => i.pgi_information2
3259: ,p_information13 => i.pgi_information3
3260: ,p_information14 => i.pgi_information4
3261: ,p_information174 => i.pgm_extra_info_id
3262: ,p_table_name => 'BEN_PGM_EXTRA_INFO'
3263: ,p_table_alias => 'PGI'
3264: ,p_object_version_number => l_ovn
3265: ,p_effective_date => to_date('1900/01/01', 'RRRR/MM/DD')
3266: ,p_dml_operation => 'UPDATE'

Line 3280: ,p_table_name => 'BEN_PGM_EXTRA_INFO'

3276: ,p_information12 => 'N'
3277: ,p_information13 => 'GL'
3278: ,p_information14 => 'AVG'
3279: ,p_information174 => null
3280: ,p_table_name => 'BEN_PGM_EXTRA_INFO'
3281: ,p_table_alias => 'PGI'
3282: ,p_object_version_number => l_ovn
3283: ,p_effective_date => to_date('1900/01/01', 'RRRR/MM/DD')
3284: ,p_dml_operation => 'UPDATE'