APPS.PAY_US_1099R_UDFS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 397: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

393: AND fdi.user_name = c_user_name;
394:
395: CURSOR get_archived_values(
396: c_user_entity_id ff_database_items.user_entity_id%type,
397: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
398: c_tax_unit_id hr_organization_units.organization_id%type)
399: IS
400: SELECT target.value
401: FROM ff_archive_item_contexts con2,

Line 415: c_assignment_action_id pay_assignment_actions.assignment_action_id%type

411: /*context of tax_unit_id */
412:
413: CURSOR get_archived_values_assignment(
414: c_user_entity_id ff_database_items.user_entity_id%type,
415: c_assignment_action_id pay_assignment_actions.assignment_action_id%type
416: )
417: IS
418: SELECT target.value
419: FROM

Line 1302: FROM pay_assignment_actions paa

1298:
1299: CURSOR get_payee_count
1300: (pact_id varchar2) IS
1301: SELECT count(paa.assignment_Action_id)
1302: FROM pay_assignment_actions paa
1303: WHERE paa.payroll_action_id = to_number(pact_id);
1304:
1305: BEGIN
1306: -- hr_utility.trace_on(NULL,'oracle');