DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on PAY_US_GET_ITEM_DATA_PKG

Line 1365: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;

1361: l_live_profile_option VARCHAR2(100);
1362: l_payroll_action_id NUMBER;
1363: l_w2_corrected VARCHAR2(10);
1364: p_effective_date DATE;
1365: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
1366: p_assignment_id NUMBER;
1367: l_person_id NUMBER;
1368: l_profile_date_string VARCHAR2(40);
1369: /* 6500188 */

Line 1745: l_full_name := pay_us_get_item_data_pkg.GET_CONTACT_PERSON_INFO(

1741: END IF;
1742: CLOSE c_get_emp_info;
1743: /* begin
1744:
1745: l_full_name := pay_us_get_item_data_pkg.GET_CONTACT_PERSON_INFO(
1746: 0 , p_effective_date ,0, ' ' ,
1747: ' ' , 'W2' , ' ' , ' ' , ' ' , l_person_id ,
1748: ' ' , l_dummy , l_dummy , l_dummy , l_dummy , l_dummy , l_dummy ,
1749: l_first_name , l_middle_name ,l_w2c_fields_c.last_name );

Line 1797: l_full_name := pay_us_get_item_data_pkg.GET_CONTACT_PERSON_INFO(

1793: CLOSE c_get_emp_info;
1794: /*
1795: begin
1796:
1797: l_full_name := pay_us_get_item_data_pkg.GET_CONTACT_PERSON_INFO(
1798: 0 , p_effective_date ,0, ' ' ,
1799: ' ' , 'W2' , ' ' , ' ' , ' ' , l_person_id ,
1800: ' ' , l_dummy , l_dummy , l_dummy , l_dummy , l_dummy , l_dummy ,
1801: l_first_name , l_middle_name ,l_w2c_fields_o.last_name );

Line 1812: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(

1808: exception when others then null;
1809: end ;*/
1810:
1811: lr_employee_addr :=
1812: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
1813: 'W2',
1814: l_person_id,
1815: p_assignment_id,
1816: p_effective_date,