[Home] [Help]
72: media to fail with Too many Cursors opened
73: 07-DEC-07 vmkulkar 115.16 6644795 Updated get_contact_person_info to capture Title
74: 6648007 using 'CS_PERSON'.
75: 05-Mar-10 emunisek 115.17 9356178 Made changes to call overloaded function format_mmref_address
76: of Package pay_us_mmrf_w2_format_record from function GET_MMREF_EMPLOYER_ADDRESS
77: to accommodate the Florida SQWL Requirement for PhoneNumber
78: 25-Aug-10 skchalla 115.20 9571133 Made changes to get the GRE Contact's(W2 Reporting Rules)
79: position titlte instead of person titile.
80: 26-Aug-10 nkjaladi 115.21 10060045 Comments closing syntax was missing. Added the same.
298: --
299: -- This procedure formats contact information fields specific to W2 reporting
300: --
301: hr_utility.trace('Formatting Contact Person Info for W2 reporting ');
302: pay_us_mmrf_w2_format_record.format_w2_contact_prsn_info(
303: p_report_qualifier,
304: p_record_name,
305: p_validate,
306: p_exclude_from_output,
498: ||' Reporting ');
499: --
500: -- Format Employee Address for W2 / SQWL
501: --
502: pay_us_mmrf_w2_format_record.format_mmref_address (
503: lr_employee_addr.full_name,
504: l_locality_company_id,
505: lr_employee_addr.employee_number,
506: lr_employee_addr.addr_line_1,
648: if (p_item_name='ER_ADDRESS' and p_report_type='SQWL' and p_format='MMREF'
649: and p_report_qualifier='FL_SQWL' and p_record_name='RE')
650: then
651:
652: pay_us_mmrf_w2_format_record.format_mmref_address (
653: substr(lr_employer_addr.org_name,1,80), -- Bug# 14286448 Gre length issue
654: l_locality_company_id,
655: l_emp_number,
656: lr_employer_addr.addr_line_1,
682: sp_out_10
683: );
684:
685: else
686: pay_us_mmrf_w2_format_record.format_mmref_address (
687: substr(lr_employer_addr.org_name,1,80), -- Bug# 14286448 Gre length issue
688: l_locality_company_id,
689: l_emp_number,
690: lr_employer_addr.addr_line_1,