DBA Data[Home] [Help]

APPS.PAY_1099R_PKG dependencies on PAY_US_GET_ITEM_DATA_PKG

Line 1200: addr pay_us_get_item_data_pkg.person_name_address;

1196: SELECT to_number(serial_number)
1197: FROM pay_assignment_actions
1198: WHERE assignment_action_id = p_fed_aaid;
1199:
1200: addr pay_us_get_item_data_pkg.person_name_address;
1201:
1202: l_employee_address VARCHAR2(300);
1203: l_address_line1 per_addresses.address_line1%TYPE;
1204: l_address_line2 per_addresses.address_line2%TYPE;

Line 1226: addr := pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(

1222: -- p_effective_date is the session_date and
1223: -- p_year_end_date will be the last day of the year for which the report is run.
1224: -- we want to fetch the address as of 31-dec if the session date is less than 31-dec of the year.
1225:
1226: addr := pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
1227: 'REPORT',
1228: l_person_id,
1229: NULL,
1230: p_year_end_date,