APPS.PQP_NL_ABP_TEMPLATE dependencies on DUAL

Line 283: FROM dual;

279: ,'FPB','FP Basis'
280: ,'AAOP','ABP Disabiliy Pension'
281: ,c_subcat
282: )
283: FROM dual;
284:
285: l_scheme_dummy VARCHAR2(10);
286:
287: -- ---------------------------------------------------------------------

Line 376: from dual;

372: and creator_type = p_creator_type;
373: exception when no_data_found then
374: select pay_retro_component_usages_s.nextval
375: into l_rc_usage_id
376: from dual;
377: --
378:
379: insert into pay_retro_component_usages(
380: RETRO_COMPONENT_USAGE_ID,

Line 445: from dual;

441: and adjustment_type is null;
442: exception when no_data_found then
443: select pay_element_span_usages_s.nextval
444: into l_es_usage_id
445: from dual;
446:
447:
448:
449: insert into pay_element_span_usages(

Line 730: FROM dual;

726: 'IPAP','I','IPBW_L','IL','IPBW_H','IH',
727: 'OPNP','O','OPNP_65','O65','OPNP_AOW','OA',
728: 'OPNP_W25','OW25','OPNP_W50','OW50',
729: 'PPP','P','VSG','V','FPB','FP','AAOP','AP')
730: FROM dual;
731:
732: BEGIN
733:
734: --encode the sub category to use it in the formula result name

Line 838: FROM dual;

834: LOOP
835:
836: SELECT pay_formula_result_rules_s.nextval
837: INTO l_formula_result_rule_id
838: FROM dual;
839:
840: pay_formula_result_rules_pkg.insert_row
841: (p_rowid => l_rowid
842: ,p_formula_result_rule_id => l_formula_result_rule_id

Line 2042: FROM dual

2038: -- for a particular element_type_id
2039: --
2040: CURSOR c_chk_rr_exist (c_element_type_id IN NUMBER) IS
2041: SELECT 1
2042: FROM dual
2043: WHERE EXISTS ( SELECT 1
2044: FROM pay_run_results prr
2045: WHERE prr.element_type_id = c_element_type_id) ;
2046: