APPS.PQP_GB_PSI_FUNCTIONS dependencies on BEN_EXT_RSLT

Line 334: -- SELECT ben_ext_rslt_s.CURRVAL

330: l_ext_rslt_id NUMBER;
331: --
332: BEGIN
333: --
334: -- SELECT ben_ext_rslt_s.CURRVAL
335: -- INTO l_ext_rslt_id
336: -- FROM DUAL;
337:
338: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;

Line 764: FROM ben_ext_rslt

760: --
761: CURSOR csr_get_ext_rslt_id
762: IS
763: SELECT ext_rslt_id
764: FROM ben_ext_rslt
765: WHERE request_id = p_request_id
766: AND business_group_id = p_business_group_id;
767:
768: l_ext_rslt_id NUMBER;

Line 1758: FROM ben_ext_rslt_dtl dtl

1754:
1755:
1756: CURSOR csr_get_ttl_rslt(c_ext_rslt_id IN Number) IS
1757: SELECT val_01,val_02,val_03,val_04,val_05
1758: FROM ben_ext_rslt_dtl dtl
1759: ,ben_ext_rcd rcd
1760: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1761: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1762: AND rcd.rcd_type_cd = 'T';

Line 1783: FROM fnd_concurrent_requests req ,ben_ext_rslt ben

1779: -- For Nuvos
1780:
1781: CURSOR csr_get_eff_date (c_ext_rslt_id IN number) IS
1782: SELECT argument8 Extract_eff_date --- For Nuvos
1783: FROM fnd_concurrent_requests req ,ben_ext_rslt ben
1784: where req.request_id = ben.request_id
1785: and ben.ext_rslt_id = c_ext_rslt_id
1786: and ben.business_group_id = p_business_group_id;
1787:

Line 1785: and ben.ext_rslt_id = c_ext_rslt_id

1781: CURSOR csr_get_eff_date (c_ext_rslt_id IN number) IS
1782: SELECT argument8 Extract_eff_date --- For Nuvos
1783: FROM fnd_concurrent_requests req ,ben_ext_rslt ben
1784: where req.request_id = ben.request_id
1785: and ben.ext_rslt_id = c_ext_rslt_id
1786: and ben.business_group_id = p_business_group_id;
1787:
1788: -- For Nuvos Earnings
1789:

Line 1794: FROM ben_ext_rslt_dtl dtl

1790: CURSOR csr_get_ern_ttl_rslt(c_ext_rslt_id IN Number) IS
1791: SELECT val_01 payhcnt,
1792: nvl(val_03,0) + nvl(val_04,0) pearntot,
1793: 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
1794: FROM ben_ext_rslt_dtl dtl
1795: ,ben_ext_rcd rcd
1796: WHERE dtl.ext_rslt_id = c_ext_rslt_id
1797: AND dtl.ext_rcd_id = rcd.ext_rcd_id
1798: AND rcd.rcd_type_cd = 'T';

Line 3048: FROM BEN_EXT_RSLT_ERR ers

3044: from ben_person_actions bpa
3045: Where bpa.benefit_action_id = c_benefit_action_id
3046: and EXISTS
3047: ( SELECT ers.PERSON_ID
3048: FROM BEN_EXT_RSLT_ERR ers
3049: WHERE ers.person_id = bpa.person_id
3050: AND ers.EXT_RSLT_ID= c_ext_rslt_id
3051: AND typ_cd = 'E');
3052:

Line 3073: FROM BEN_EXT_RSLT_ERR

3069: Set bpa.action_status_cd = 'U'
3070: Where bpa.benefit_action_id = l_ben_params.benefit_action_id -- 3629 -- p_benefit_action_id
3071: and bpa.person_id -- = p_person_id;
3072: IN ( SELECT PERSON_ID
3073: FROM BEN_EXT_RSLT_ERR
3074: WHERE EXT_RSLT_ID= Ben_Ext_Thread.g_ext_rslt_id -- 2891 -- c_ext_rslt_id
3075: AND typ_cd = 'E');
3076:
3077: Update ben_batch_ranges bbr

Line 3082: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere

3078: set bbr.range_status_cd = 'E'
3079: Where bbr.benefit_action_id = l_ben_params.benefit_action_id
3080: AND EXISTS(
3081: Select 1 -- distinct(bere.person_id)
3082: From ben_person_actions bpa, BEN_EXT_RSLT_ERR bere
3083: Where bpa.benefit_action_id = l_ben_params.benefit_action_id
3084: AND bbr.benefit_action_id = bpa.benefit_action_id
3085: AND (bpa.person_action_id Between
3086: bbr.starting_person_action_id And bbr.ending_person_action_id)

Line 3134: FROM BEN_EXT_RSLT_ERR ers

3130: CURSOR csr_err_person_id
3131: (p_ext_rslt_id IN NUMBER)
3132: IS
3133: SELECT distinct(ers.PERSON_ID)
3134: FROM BEN_EXT_RSLT_ERR ers
3135: WHERE ers.EXT_RSLT_ID = p_ext_rslt_id
3136: AND typ_cd = 'E';
3137:
3138: CURSOR csr_range_id

Line 3349: update ben_ext_rslt

3345: l_file_name := l_extract_code.output_name || g_paypoint || '.' || g_sequence_number;
3346:
3347: debug('l_file_name :' || l_file_name );
3348:
3349: update ben_ext_rslt
3350: SET output_name = l_file_name
3351: WHERE business_group_id = l_business_group_id
3352: AND ext_rslt_id = ben_ext_thread.g_ext_rslt_id;
3353:

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

3383: -- RAISE_EXTRACT_WARNING
3384: --
3385: -- "Smart" warning function.
3386: -- When called from the Rule of a extract detail data element
3387: -- it logs a warning in the ben_ext_rslt_err table against
3388: -- the person being processed (or as specified by context of
3389: -- assignment id ). It prefixes all warning messages with a
3390: -- string "Warning raised in data element "||element_name
3391: -- This allows the same Rule to be called from different data

Line 4866: FROM ben_ext_rslt

4862: -- Cursor to fetch the last successful approved run date
4863: CURSOR csr_get_run_date
4864: IS
4865: SELECT MAX(eff_dt)
4866: FROM ben_ext_rslt
4867: WHERE ext_dfn_id = ben_ext_thread.g_ext_dfn_id
4868: AND business_group_id = g_business_group_id
4869: AND ext_stat_cd = 'A';
4870: */