APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT_DTL

Line 133: ,new_ext_emp_cat_cd ben_ext_rslt_dtl.val_01%TYPE

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

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

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

Line 1066: FROM ben_ext_rslt_dtl dtl

1062: CURSOR csr_rslt_dtl(p_person_id IN NUMBER
1063: ,p_ext_rslt_id IN NUMBER
1064: ) IS
1065: SELECT *
1066: FROM ben_ext_rslt_dtl dtl
1067: WHERE dtl.ext_rslt_id = p_ext_rslt_id
1068: AND dtl.person_id = p_person_id
1069: AND dtl.ext_rcd_id = g_ext_dtl_rcd_id;
1070:

Line 1806: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE

1802: --
1803: -- type1_post_proc_rule
1804: --
1805: FUNCTION type1_post_proc_rule
1806: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE
1807: ) RETURN VARCHAR2;
1808:
1809: --
1810: -- Added this procedure to the header as there was a GSCC