DBA Data[Home] [Help]

APPS.PAY_1099R_PKG dependencies on PAY_US_GET_ITEM_DATA_PKG

Line 1184: addr pay_us_get_item_data_pkg.person_name_address;

1180: SELECT to_number(serial_number)
1181: FROM pay_assignment_actions
1182: WHERE assignment_action_id = p_fed_aaid;
1183:
1184: addr pay_us_get_item_data_pkg.person_name_address;
1185:
1186: l_employee_address VARCHAR2(300);
1187: l_address_line1 per_addresses.address_line1%TYPE;
1188: l_address_line2 per_addresses.address_line2%TYPE;

Line 1210: addr := pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(

1206: -- p_effective_date is the session_date and
1207: -- p_year_end_date will be the last day of the year for which the report is run.
1208: -- we want to fetch the address as of 31-dec if the session date is less than 31-dec of the year.
1209:
1210: addr := pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
1211: 'REPORT',
1212: l_person_id,
1213: NULL,
1214: p_year_end_date,