APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on DUAL

Line 169: individual data records.

165: compare_archive_data so that if the
166: number of archived items to be compared
167: is different then the amendment flag is
168: set to Y without checking all the
169: individual data records.
170: 21-FEB-2004 pganguly 115.55 Fixed bug# 3459723. Changed the cursor
171: c_get_asg_id so that it picks
172: assignment of type 'E' only.
173: 02-APR-2004 ssattini 115.56 11510 Changes to fix bug#3356533.

Line 471: individual reports where they are different from the

467: p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
468: for the testing of the balance.
469:
470: Notes : This routine provides a way of coding explicit rules for
471: individual reports where they are different from the
472: standard selection criteria for the report type ie. in
473: NY state the selection of people in the 4th quarter is
474: different from the first 3.
475: */

Line 1515: from dual;

1511: combination. */
1512:
1513: select pay_assignment_actions_s.nextval
1514: into lockingactid
1515: from dual;
1516:
1517: /* Insert into pay_assignment_actions. */
1518:
1519: hr_utility.trace('creating assignment action');

Line 2094: from dual

2090: l_flag varchar2(1);
2091:
2092: cursor c_chk_payroll_action is
2093: select 'Y'
2094: from dual
2095: where exists (select null
2096: from ff_archive_items fai
2097: where fai.context1 = p_payroll_action_id);
2098: begin

Line 2267: from dual;

2263: hr_utility.trace('l_start_seq_num = '||l_start_seq_num);
2264: hr_utility.trace('l_end_seq_num = '||l_end_seq_num);
2265:
2266: select PAY_CA_RL1_PDF_SEQ_COUNT_S.nextval into l_seq_offset
2267: from dual;
2268: l_final_seq_num := getnext_seq_num(l_start_seq_num + l_seq_offset);
2269:
2270: hr_utility.trace('l_seq_offset = '||l_seq_offset);
2271: hr_utility.trace('l_final_seq_num = '||l_final_seq_num);

Line 2396: into l_rl1_curr_slip_number from dual;*/

2392: hr_utility.trace('2');
2393:
2394: -- Added for bug 11694701
2395: /*select l_rl1_last_slip_number + pay_ca_eoy_rl1_s.nextval - 1
2396: into l_rl1_curr_slip_number from dual;*/
2397: select l_rl1_starting_slip_num + pay_ca_eoy_rl1_s.nextval - 1
2398: into l_rl1_curr_slip_number from dual;
2399: hr_utility.trace('l_rl1_curr_slip_number: '||l_rl1_curr_slip_number);
2400:

Line 2398: into l_rl1_curr_slip_number from dual;

2394: -- Added for bug 11694701
2395: /*select l_rl1_last_slip_number + pay_ca_eoy_rl1_s.nextval - 1
2396: into l_rl1_curr_slip_number from dual;*/
2397: select l_rl1_starting_slip_num + pay_ca_eoy_rl1_s.nextval - 1
2398: into l_rl1_curr_slip_number from dual;
2399: hr_utility.trace('l_rl1_curr_slip_number: '||l_rl1_curr_slip_number);
2400:
2401: if l_rl1_ending_slip_num is not NULL and l_rl1_curr_slip_number is not NULL
2402: and l_rl1_curr_slip_number > l_rl1_ending_slip_num then

Line 2412: from dual;

2408: hr_utility.trace('1');
2409:
2410: select mod(l_rl1_curr_slip_number,7)
2411: into l_rl1_slip_number_last_digit
2412: from dual;
2413:
2414: hr_utility.trace('l_rl1_slip_number_last_digit : '|| l_rl1_slip_number_last_digit);
2415:
2416: /* Commented and modified as below by sneelapa, bug 11654691

Line 4102: /* Archive BOXO, which is sum of all the individual

4098: end if;
4099:
4100: end loop;
4101:
4102: /* Archive BOXO, which is sum of all the individual
4103: balances under BOXO, also determine the correct
4104: BOXO code that needs to be archived */
4105:
4106: l_user_entity_value_tab_boxo := 0;