APPS.PYUDET dependencies on PAY_GB_TAX_CODE_INTERFACE

Line 236: from pay_gb_tax_code_interface tci

232: to_char(nvl((tci.tot_tax_prev_emp/100),'')) tax_previous_sv,
233: upper(nvl(tci.form_type,'')) authority_sv,
234: ltrim(rtrim(to_char(tci.district_number,'000'))) || '/' || ltrim(rtrim(tci.employer_reference)) paye_ref,
235: tci.rowid row_id
236: from pay_gb_tax_code_interface tci
237: where tci.processed_flag is null
238: and ( tci.request_id is null
239: or tci.request_id = g_p6_request_id)
240: -- Bug 6957644 modified 6,2 to date_of_message,upper(full_name) to report order by name

Line 662: from pay_gb_tax_code_interface

658: PROCEDURE write_header
659: IS
660: cursor c_p6 is
661: select count(*)
662: from pay_gb_tax_code_interface
663: where request_id = g_p6_request_id;
664:
665: l_process varchar2(110);
666: l_mode varchar2(100);

Line 954: update pay_gb_tax_code_interface

950: elsif (g_mode in (3,4)) then
951: ----------------------------------------
952: -- First update the taxcode interface --
953: ----------------------------------------
954: update pay_gb_tax_code_interface
955: set processed_flag = 'R'
956: where rowid = p_m34_rec.row_id;
957: --
958: if p_asg_number is not null then

Line 986: from pay_gb_tax_code_interface

982: IS
983: l_p6_count number;
984: cursor p6 is
985: select count(*)
986: from pay_gb_tax_code_interface
987: where request_id = g_p6_request_id
988: and processed_flag = 'P';
989: BEGIN
990: file_output('P', g_P_line_count, null, g_request_id);

Line 2025: select rowid from pay_gb_tax_code_interface

2021: l_row_id rowid;
2022: l_num_entry_values number;
2023:
2024: cursor c1 (c_row_id in rowid) is
2025: select rowid from pay_gb_tax_code_interface
2026: where rowid = c_row_id
2027: for update;
2028:
2029: BEGIN

Line 2066: update pay_gb_tax_code_interface

2062: ---------------------------------------------------
2063: if (g_mode in (3,4)) then
2064: open c1(p_m34_rec.row_id);
2065: fetch c1 into l_row_id;
2066: update pay_gb_tax_code_interface
2067: set processed_flag = 'P'
2068: where current of c1;
2069: close c1;
2070: end if;

Line 2413: delete pay_gb_tax_code_interface

2409:
2410: -- Clear out the Tax Code Interface table
2411: if g_mode in (3,4) then
2412: hr_utility.trace('Clearing tax code interface');
2413: delete pay_gb_tax_code_interface
2414: where (request_id is null or request_id = g_p6_request_id)
2415: and processed_flag = 'P'; /*Added soy 08-09*/
2416: commit;
2417: end if;