APPS.PYUDET dependencies on PAY_GB_TAX_CODE_INTERFACE

Line 313: from pay_gb_tax_code_interface tci

309: to_char(nvl((tci.tot_tax_prev_emp/100),'')) tax_previous_sv,
310: upper(nvl(tci.form_type,'')) authority_sv,
311: ltrim(rtrim(to_char(tci.district_number,'000'))) || '/' || ltrim(rtrim(tci.employer_reference)) paye_ref,
312: tci.rowid row_id
313: from pay_gb_tax_code_interface tci
314: where tci.processed_flag is null
315: and ( tci.request_id is null
316: or tci.request_id = g_p6_request_id)
317: -- Bug 6957644 modified 6,2 to date_of_message,upper(full_name) to report order by name

Line 781: from pay_gb_tax_code_interface

777: PROCEDURE write_header
778: IS
779: cursor c_p6 is
780: select count(*)
781: from pay_gb_tax_code_interface
782: where request_id = g_p6_request_id;
783:
784: l_process varchar2(110);
785: l_mode varchar2(100);

Line 1077: update pay_gb_tax_code_interface

1073: elsif (g_mode in (3,4)) then
1074: ----------------------------------------
1075: -- First update the taxcode interface --
1076: ----------------------------------------
1077: update pay_gb_tax_code_interface
1078: set processed_flag = 'R'
1079: where rowid = p_m34_rec.row_id;
1080: --
1081: if p_asg_number is not null then

Line 1112: from pay_gb_tax_code_interface

1108: IS
1109: l_p6_count number;
1110: cursor p6 is
1111: select count(*)
1112: from pay_gb_tax_code_interface
1113: where request_id = g_p6_request_id
1114: and processed_flag = 'P';
1115: BEGIN
1116: file_output('P', g_P_line_count, null, g_request_id);

Line 2401: select rowid from pay_gb_tax_code_interface

2397: l_row_id rowid;
2398: l_num_entry_values number;
2399:
2400: cursor c1 (c_row_id in rowid) is
2401: select rowid from pay_gb_tax_code_interface
2402: where rowid = c_row_id
2403: for update;
2404:
2405: BEGIN

Line 2450: update pay_gb_tax_code_interface

2446: ---------------------------------------------------
2447: if (g_mode in (3,4)) then
2448: open c1(p_m34_rec.row_id);
2449: fetch c1 into l_row_id;
2450: update pay_gb_tax_code_interface
2451: set processed_flag = 'P'
2452: where current of c1;
2453: close c1;
2454: end if;

Line 3053: delete pay_gb_tax_code_interface

3049:
3050: -- Clear out the Tax Code Interface table
3051: if g_mode in (3,4) then
3052: hr_utility.trace('Clearing tax code interface');
3053: delete pay_gb_tax_code_interface
3054: where (request_id is null or request_id = g_p6_request_id)
3055: and processed_flag = 'P'; /*Added soy 08-09*/
3056: commit;
3057: end if;