eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2236: type t_assignment_extra_info_tab is table of per_assignment_extra_info.assignment_extra_info_id%TYPE index by binary_integer;

2232:
2233: type t_user_entity_name_tab is table of ff_user_entities.user_entity_name%TYPE index by binary_integer;
2234: t_user_entity_name_a8b t_user_entity_name_tab;
2235:
2236: type t_assignment_extra_info_tab is table of per_assignment_extra_info.assignment_extra_info_id%TYPE index by binary_integer;
2237: t_aeid_a8b t_assignment_extra_info_tab;
2238:
2239: type shares_amend_rec is record
2240: ( person_extra_info_id per_people_extra_info.person_extra_info_id%type,

Line 2342: c_assignment_id per_assignment_extra_info.assignment_id%type,

2338: --
2339:
2340: cursor shares_removed
2341: (c_user_entity_id ff_user_entities.user_entity_id%type,
2342: c_assignment_id per_assignment_extra_info.assignment_id%type,
2343: c_person_id per_people_f.person_id%type,
2344: c_tax_unit_id ff_archive_item_contexts.context%type) is
2345:
2346: select distinct con2.context person_extra_info_id

Line 2873: type t_assignment_extra_info_tab is table of per_assignment_extra_info.assignment_extra_info_id%TYPE index by binary_integer;

2869: type t_user_entity_name_tab is table of ff_user_entities.user_entity_name%TYPE index by binary_integer;
2870: t_user_entity_name_ir8s_c t_user_entity_name_tab;
2871:
2872:
2873: type t_assignment_extra_info_tab is table of per_assignment_extra_info.assignment_extra_info_id%TYPE index by binary_integer;
2874: t_aeid_ir8s_c t_assignment_extra_info_tab;
2875:
2876: type ir8s_c_rec is record
2877: ( assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

Line 2877: ( assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,

2873: type t_assignment_extra_info_tab is table of per_assignment_extra_info.assignment_extra_info_id%TYPE index by binary_integer;
2874: t_aeid_ir8s_c t_assignment_extra_info_tab;
2875:
2876: type ir8s_c_rec is record
2877: ( assignment_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type,
2878: value number );
2879: type ir8s_c_value_tab is table of ir8s_c_rec index by binary_integer;
2880: value_ir8s_c ir8s_c_value_tab;
2881:

Line 2905: per_assignment_extra_info aei,

2901: aei.aei_information9 ee_cpf,
2902: aei.aei_information10 ee_cpf_interest,
2903: aei.aei_information11 ee_cpf_date
2904: from per_assignments_f ass,
2905: per_assignment_extra_info aei,
2906: hr_soft_coding_keyflex hsc
2907: where ass.person_id = c_person_id
2908: and ass.assignment_id = aei.assignment_id
2909: and ass.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id

Line 2923: c_assignment_id per_assignment_extra_info.assignment_id%type,

2919: and ass.effective_end_date >= c_basis_start);
2920:
2921: cursor ir8s_c_removed
2922: (c_user_entity_id ff_user_entities.user_entity_id%type,
2923: c_assignment_id per_assignment_extra_info.assignment_id%type,
2924: c_tax_unit_id ff_archive_item_contexts.context%type) is
2925:
2926: select distinct con2.context assignment_extra_info_id
2927: from ff_archive_items arch,

Line 2950: from per_assignment_extra_info aei

2946: and con1.sequence_no =2)
2947: and arch.archive_item_id = con2.archive_item_id
2948: and con2.sequence_no = 3
2949: and not exists (select 1
2950: from per_assignment_extra_info aei
2951: where aei.assignment_id = c_assignment_id
2952: and aei.assignment_extra_info_id = con2.context);
2953:
2954: