APPS.PAY_CA_USER_INIT_EARN dependencies on DUAL

Line 552: FROM dual;

548: SELECT
549: DECODE(p_ele_classification,'Earnings','DE',
550: 'Supplemental Earnings','DE','Taxable Benefits','DE','')
551: INTO l_roe_allocation_by
552: FROM dual;
553: --
554: SELECT
555: DECODE(p_ele_classification,
556: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),

Line 561: FROM dual;

557: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
558: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
559: '')
560: INTO l_sf_ele_category
561: FROM dual;
562: --
563: SELECT
564: DECODE(p_ele_classification,
565: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),

Line 570: FROM dual;

566: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
567: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
568: '')
569: INTO l_sf_ele_info_category
570: FROM dual;
571: --
572: -- Update user-specified Classification, Category,
573: -- Processing Type and Standard Link.
574: --

Line 992: from dual;

988: if etu.element_information4 is not null then
989: select 'REG_' ||
990: replace(etu.element_information4,'/','_') earn_shortname
991: into lv_earn_shortname
992: from dual;
993: else
994: lv_earn_shortname := 'REG_T4_RL1';
995: end if;
996: else

Line 1002: from dual;

998: 'N','NP_',
999: 'L','LS_', NULL)||
1000: replace(etu.element_information4,'/','_') earn_shortname
1001: into lv_earn_shortname
1002: from dual;
1003: end if;
1004:
1005: end if;
1006: hr_utility.trace('ln_run_type_id : '||ln_run_type_id);

Line 1343: FROM dual;

1339: hr_utility.set_location(l_proc,42);
1340: --
1341: SELECT pay_formula_result_rules_s.nextval
1342: INTO l_nextval
1343: FROM dual;
1344: --
1345: hr_utility.set_location(l_proc,43);
1346: --
1347: OPEN c_base_elmt_spr_id;