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.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_RCD

Line 10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;

6: g_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
7: g_action_effective_date DATE;
8: g_action_type VARCHAR2(50);
9: g_asgrun_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
10: g_ext_dtl_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
11: g_business_group_id per_business_groups.business_group_id%TYPE;
12: g_person_id per_all_assignments_f.person_id%TYPE;
13: g_index_fur NUMBER := 0;
14: g_count_fur NUMBER := 0;

Line 152: TYPE ben_ext_rcds IS RECORD

148: TYPE t_retro_hires IS TABLE OF retro_hires INDEX BY BINARY_INTEGER;
149: g_retro_hires t_retro_hires;
150:
151:
152: TYPE ben_ext_rcds IS RECORD
153: (record_number Varchar2(3)
154: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE

Line 154: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE

150:
151:
152: TYPE ben_ext_rcds IS RECORD
153: (record_number Varchar2(3)
154: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
157: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
158: );

Line 155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE

151:
152: TYPE ben_ext_rcds IS RECORD
153: (record_number Varchar2(3)
154: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
157: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
158: );
159: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;

Line 156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE

152: TYPE ben_ext_rcds IS RECORD
153: (record_number Varchar2(3)
154: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
157: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
158: );
159: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
160: g_ext_rcds t_g_ext_rcds;

Line 157: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE

153: (record_number Varchar2(3)
154: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE
155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
157: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
158: );
159: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
160: g_ext_rcds t_g_ext_rcds;
161:

Line 159: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;

155: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE
156: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
157: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE
158: );
159: TYPE t_g_ext_rcds IS TABLE OF ben_ext_rcds INDEX BY Binary_Integer;
160: g_ext_rcds t_g_ext_rcds;
161:
162: TYPE balance_details IS RECORD
163: ( balance_name pay_balance_types.balance_name%TYPE

Line 172: ( ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE

168: g_balance_detls t_balance_details;
169:
170: --Record ID s with Seq numbers
171: TYPE rcd_dtls IS RECORD
172: ( ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE
173: );
174: TYPE t_rcd_dtls IS TABLE OF rcd_dtls INDEX BY Binary_Integer;
175: g_rcd_dtls t_rcd_dtls;
176: g_retro_rcd t_rcd_dtls;