APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_RSLT

Line 270: -- SELECT ben_ext_rslt_s.CURRVAL

266: l_ext_rslt_id NUMBER;
267: --
268: BEGIN
269: --
270: -- SELECT ben_ext_rslt_s.CURRVAL
271: -- INTO l_ext_rslt_id
272: -- FROM DUAL;
273:
274: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

Line 700: FROM ben_ext_rslt

696: --
697: CURSOR csr_get_ext_rslt_id
698: IS
699: SELECT ext_rslt_id
700: FROM ben_ext_rslt
701: WHERE request_id = p_request_id
702: AND business_group_id = p_business_group_id;
703:
704: l_ext_rslt_id NUMBER;

Line 1694: FROM ben_ext_rslt_dtl dtl

1690:
1691:
1692: CURSOR csr_get_ttl_rslt(c_ext_rslt_id IN Number) IS
1693: SELECT val_01,val_02,val_03,val_04,val_05
1694: FROM ben_ext_rslt_dtl dtl
1695: ,ben_ext_rcd rcd
1696: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1697: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1698: AND rcd.rcd_type_cd = 'T';

Line 1719: FROM fnd_concurrent_requests req ,ben_ext_rslt ben

1715: -- For Nuvos
1716:
1717: CURSOR csr_get_eff_date (c_ext_rslt_id IN number) IS
1718: SELECT argument8 Extract_eff_date --- For Nuvos
1719: FROM fnd_concurrent_requests req ,ben_ext_rslt ben
1720: where req.request_id = ben.request_id
1721: and ben.ext_rslt_id = c_ext_rslt_id
1722: and ben.business_group_id = p_business_group_id;
1723:

Line 1721: and ben.ext_rslt_id = c_ext_rslt_id

1717: CURSOR csr_get_eff_date (c_ext_rslt_id IN number) IS
1718: SELECT argument8 Extract_eff_date --- For Nuvos
1719: FROM fnd_concurrent_requests req ,ben_ext_rslt ben
1720: where req.request_id = ben.request_id
1721: and ben.ext_rslt_id = c_ext_rslt_id
1722: and ben.business_group_id = p_business_group_id;
1723:
1724: -- For Nuvos Earnings
1725:

Line 1730: FROM ben_ext_rslt_dtl dtl

1726: CURSOR csr_get_ern_ttl_rslt(c_ext_rslt_id IN Number) IS
1727: SELECT val_01 payhcnt,
1728: nvl(val_03,0) + nvl(val_04,0) pearntot,
1729: nvl(val_02,0) + nvl(val_05,0) + nvl(val_06,0) + nvl(val_07,0) + nvl(val_08,0) + nvl(val_09,0) + nvl(val_10,0) + nvl(val_11,0) + nvl(val_12,0) pdedstot
1730: FROM ben_ext_rslt_dtl dtl
1731: ,ben_ext_rcd rcd
1732: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1733: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1734: AND rcd.rcd_type_cd = 'T';

Line 2984: FROM BEN_EXT_RSLT_ERR ers

2980: from ben_person_actions bpa
2981: Where bpa.benefit_action_id = c_benefit_action_id
2982: and EXISTS
2983: ( SELECT ers.PERSON_ID
2984: FROM BEN_EXT_RSLT_ERR ers
2985: WHERE ers.person_id = bpa.person_id
2986: AND ers.EXT_RSLT_ID= c_ext_rslt_id
2987: AND typ_cd = 'E');
2988:

Line 3009: FROM BEN_EXT_RSLT_ERR

3005: Set bpa.action_status_cd = 'U'
3006: Where bpa.benefit_action_id = l_ben_params.benefit_action_id -- 3629 -- p_benefit_action_id
3007: and bpa.person_id -- = p_person_id;
3008: IN ( SELECT PERSON_ID
3009: FROM BEN_EXT_RSLT_ERR
3010: WHERE EXT_RSLT_ID= Ben_Ext_Thread.g_ext_rslt_id -- 2891 -- c_ext_rslt_id
3011: AND typ_cd = 'E');
3012:
3013: Update ben_batch_ranges bbr

Line 3018: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere

3014: set bbr.range_status_cd = 'E'
3015: Where bbr.benefit_action_id = l_ben_params.benefit_action_id
3016: AND EXISTS(
3017: Select 1 -- distinct(bere.person_id)
3018: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere
3019: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3020: AND bbr.benefit_action_id = bpa.benefit_action_id
3021: AND (bpa.person_action_id Between
3022: bbr.starting_person_action_id And bbr.ending_person_action_id)

Line 3070: FROM BEN_EXT_RSLT_ERR ers

3066: CURSOR csr_err_person_id
3067: (p_ext_rslt_id IN NUMBER)
3068: IS
3069: SELECT distinct(ers.PERSON_ID)
3070: FROM BEN_EXT_RSLT_ERR ers
3071: WHERE ers.EXT_RSLT_ID = p_ext_rslt_id
3072: AND typ_cd = 'E';
3073:
3074: CURSOR csr_range_id

Line 3285: update ben_ext_rslt

3281: l_file_name := l_extract_code.output_name || g_paypoint || '.' || g_sequence_number;
3282:
3283: debug('l_file_name :' || l_file_name );
3284:
3285: update ben_ext_rslt
3286: SET output_name = l_file_name
3287: WHERE business_group_id = l_business_group_id
3288: AND ext_rslt_id = ben_ext_thread.g_ext_rslt_id;
3289:

Line 3323: -- it logs a warning in the ben_ext_rslt_err table against

3319: -- RAISE_EXTRACT_WARNING
3320: --
3321: -- "Smart" warning function.
3322: -- When called from the Rule of a extract detail data element
3323: -- it logs a warning in the ben_ext_rslt_err table against
3324: -- the person being processed (or as specified by context of
3325: -- assignment id ). It prefixes all warning messages with a
3326: -- string "Warning raised in data element "||element_name
3327: -- This allows the same Rule to be called from different data

Line 4794: FROM ben_ext_rslt

4790: -- Cursor to fetch the last successful approved run date
4791: CURSOR csr_get_run_date
4792: IS
4793: SELECT MAX(eff_dt)
4794: FROM ben_ext_rslt
4795: WHERE ext_dfn_id = ben_ext_thread.g_ext_dfn_id
4796: AND business_group_id = g_business_group_id
4797: AND ext_stat_cd = 'A';
4798: */