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 150: TYPE ben_ext_rcds IS RECORD

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

Line 152: ,record_seqnum ben_ext_rcd_in_file.seq_num%TYPE

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

Line 153: ,hide_flag ben_ext_rcd_in_file.hide_flag%TYPE

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

Line 154: ,ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE

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

Line 155: ,rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE

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

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

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

Line 170: ( ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE

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