APPS.PAY_CA_USER_INIT_EARN dependencies on DUAL

Line 557: FROM dual;

553: SELECT
554: DECODE(p_ele_classification,'Earnings','DE',
555: 'Supplemental Earnings','DE','Taxable Benefits','DE','')
556: INTO l_roe_allocation_by
557: FROM dual;
558: --
559: SELECT
560: DECODE(p_ele_classification,
561: 'Earnings',nvl(p_ele_category, hr_api.g_varchar2),

Line 566: FROM dual;

562: 'Supplemental Earnings',nvl(p_ele_category, hr_api.g_varchar2),
563: 'Taxable Benefits',nvl(p_ele_category, hr_api.g_varchar2),
564: '')
565: INTO l_sf_ele_category
566: FROM dual;
567: --
568: SELECT
569: DECODE(p_ele_classification,
570: 'Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),

Line 575: FROM dual;

571: 'Supplemental Earnings', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
572: 'Taxable Benefits', nvl(upper(g_template_leg_code||'_'||p_ele_classification), hr_api.g_varchar2),
573: '')
574: INTO l_sf_ele_info_category
575: FROM dual;
576: --
577: -- Update user-specified Classification, Category,
578: -- Processing Type and Standard Link.
579: --

Line 1000: from dual;

996: if etu.element_information4 is not null then
997: select 'REG_' ||
998: replace(etu.element_information4,'/','_') earn_shortname
999: into lv_earn_shortname
1000: from dual;
1001: else
1002: lv_earn_shortname := 'REG_T4_RL1';
1003: end if;
1004: else

Line 1010: from dual;

1006: 'N','NP_',
1007: 'L','LS_', NULL)||
1008: replace(etu.element_information4,'/','_') earn_shortname
1009: into lv_earn_shortname
1010: from dual;
1011: end if;
1012:
1013: end if;
1014: hr_utility.trace('ln_run_type_id : '||ln_run_type_id);

Line 1351: FROM dual;

1347: hr_utility.set_location(l_proc,42);
1348: --
1349: SELECT pay_formula_result_rules_s.nextval
1350: INTO l_nextval
1351: FROM dual;
1352: --
1353: hr_utility.set_location(l_proc,43);
1354: --
1355: OPEN c_base_elmt_spr_id;