APPS.PAY_JP_ISDF_RPT dependencies on DUAL

Line 348: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;

344: FOR i IN c_assact(l_old_pact_id,l_prn_app_opt) LOOP
345: -- Added NVL to overcome NULL issue.
346: IF (NVL(l_ass_set_id,0) = 0) THEN
347: -- NO assignment set passed as parameter
348: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
349: hr_nonrun_asact.insact(l_assact,
350: i.assignment_id ,
351: p_payroll_action_id,
352: p_chunk,

Line 366: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;

362: IF (g_all_exclusions_flag = 0) THEN
363: -- assignment set by ammmendment passed is not all exclusions.
364: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
365: IF (l_result1 = 'I') THEN
366: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
367: hr_nonrun_asact.insact(l_assact,
368: i.assignment_id ,
369: p_payroll_action_id,
370: p_chunk,

Line 378: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;

374: ELSE
375: -- assignment set by ammmendment passed is all exclusions.
376: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
377: IF (l_result1 <> 'E') THEN
378: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
379: hr_nonrun_asact.insact(l_assact,
380: i.assignment_id ,
381: p_payroll_action_id,
382: p_chunk,

Line 392: SELECT pay_assignment_actions_s.nextval into l_assact from dual;

388: ELSE
389: -- assignment set by criteria passed
390: l_result2 := chk_ass_set(i.assignment_id, l_ass_set_id, l_formula_id, i.effective_date, g_dummy);
391: IF (l_result2 = TRUE) THEN
392: SELECT pay_assignment_actions_s.nextval into l_assact from dual;
393: hr_nonrun_asact.insact(l_assact,
394: i.assignment_id ,
395: p_payroll_action_id,
396: p_chunk,

Line 1420: from dual;

1416: IF (ins_company_name_lp.count >= d) THEN
1417: --
1418: select to_char(ins_period_start_date_lp(d),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1419: into ps_date
1420: from dual;
1421: --
1422: -- ps_date_length := length(ins_period_start_date_lp(d));
1423: ps_date_length := length(ps_date);
1424: --

Line 1455: from dual;

1451: IF (ins_company_name_lp.count >= e) THEN
1452: --
1453: select to_char(ins_period_start_date_lp(e),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1454: into ps_date
1455: from dual;
1456: --
1457: ps_date_length := length(ps_date);
1458: --
1459: l_xml := l_xml||''||htmlspchar(cnv_str(ins_company_name_lp(e))) ||''||EOL; --ins_company_name_lp2

Line 1489: from dual;

1485: IF (ins_company_name_lp.count >= g) THEN
1486: --
1487: select to_char(ins_period_start_date_lp(g),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1488: into ps_date
1489: from dual;
1490: --
1491: ps_date_length := length(ps_date);
1492: --
1493: if class_new_old_lp(g) = 'N' then

Line 1536: from dual;

1532: IF (ins_company_name_lp.count >= h) THEN
1533: --
1534: select to_char(ins_period_start_date_lp(h),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1535: into ps_date
1536: from dual;
1537: --
1538: ps_date_length := length(ps_date);
1539: --
1540: if class_new_old_lp(h) = 'N' then

Line 1584: from dual;

1580: IF (ins_company_name_lp.count >= j) THEN
1581: --
1582: select to_char(ins_period_start_date_lp(j),'EEYYMMDD"','NLS_CALENDAR=''Japanese Imperial''')
1583: into ps_date
1584: from dual;
1585: --
1586: ps_date_length := length(ps_date);
1587: --
1588: if class_new_old_lp(j) = 'N' then

Line 2035: -- since this file is now dual checkin maintenanced

2031: Arguments :
2032: Description :
2033: *****************************************************************************/
2034: -- decommission in accordance with parameter change by bug 10273341 for 12.2
2035: -- since this file is now dual checkin maintenanced
2036: -- and not used in any product code
2037: /*
2038: --function submit_report(p_pact_id IN NUMBER,
2039: -- p_assset_id IN NUMBER,