APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 32: g_header_system_element ben_ext_rslt_dtl.val_01%type;--8996926

28: g_crossbg_enabled VARCHAR2(1) := 'N';
29: g_cross_per_enabled VARCHAR2(1);
30: g_estb_number VARCHAR2(4):='0000';
31: g_originators_title VARCHAR2(16);
32: g_header_system_element ben_ext_rslt_dtl.val_01%type;--8996926
33:
34: g_reporting_mode VARCHAR2(10);
35: g_trace VARCHAR2(1) := NULL;
36:

Line 136: ,new_ext_emp_cat_cd ben_ext_rslt_dtl.val_01%TYPE

132: TYPE stored_events_type IS RECORD
133: (event_date DATE
134: ,event_type VARCHAR2(24000)
135: ,assignment_id per_all_assignments_f.assignment_id%TYPE
136: ,new_ext_emp_cat_cd ben_ext_rslt_dtl.val_01%TYPE
137: -- Bugfix 3470242:BUG1 : Now storing location_id as estb_number can
138: -- always be sought using location id
139: -- ,new_estb_number ben_ext_rslt_dtl.val_01%TYPE
140: ,new_location_id per_all_assignments_f.location_id%TYPE

Line 139: -- ,new_estb_number ben_ext_rslt_dtl.val_01%TYPE

135: ,assignment_id per_all_assignments_f.assignment_id%TYPE
136: ,new_ext_emp_cat_cd ben_ext_rslt_dtl.val_01%TYPE
137: -- Bugfix 3470242:BUG1 : Now storing location_id as estb_number can
138: -- always be sought using location id
139: -- ,new_estb_number ben_ext_rslt_dtl.val_01%TYPE
140: ,new_location_id per_all_assignments_f.location_id%TYPE
141: ,pt_asg_count_change NUMBER
142: -- Added for bugfix 3803760:TERMASG
143: ,asg_count_change NUMBER

Line 1075: FROM ben_ext_rslt_dtl dtl

1071: CURSOR csr_rslt_dtl(p_person_id IN NUMBER
1072: ,p_ext_rslt_id IN NUMBER
1073: ) IS
1074: SELECT *
1075: FROM ben_ext_rslt_dtl dtl
1076: WHERE dtl.ext_rslt_id = p_ext_rslt_id
1077: AND dtl.person_id = p_person_id
1078: AND dtl.ext_rcd_id = g_ext_dtl_rcd_id;
1079:

Line 1085: FROM ben_ext_rslt_dtl dtl

1081: CURSOR csr_rslt_dtl_sort(p_person_id IN NUMBER
1082: ,p_ext_rslt_id IN NUMBER
1083: ) IS
1084: SELECT *
1085: FROM ben_ext_rslt_dtl dtl
1086: WHERE dtl.ext_rslt_id = p_ext_rslt_id
1087: AND dtl.person_id = p_person_id
1088: AND dtl.ext_rcd_id = g_ext_dtl_rcd_id
1089: ORDER BY dtl.thrd_sort_val;

Line 1827: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE

1823: --
1824: -- type1_post_proc_rule
1825: --
1826: FUNCTION type1_post_proc_rule
1827: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE
1828: ) RETURN VARCHAR2;
1829:
1830: --
1831: -- Added this procedure to the header as there was a GSCC