DBA Data[Home] [Help]

APPS.PAY_US_1099R_UDFS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 401: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

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

Line 419: c_assignment_action_id pay_assignment_actions.assignment_action_id%type

415: /*context of tax_unit_id */
416:
417: CURSOR get_archived_values_assignment(
418: c_user_entity_id ff_database_items.user_entity_id%type,
419: c_assignment_action_id pay_assignment_actions.assignment_action_id%type
420: )
421: IS
422: SELECT target.value
423: FROM

Line 1326: FROM pay_assignment_actions paa

1322:
1323: CURSOR get_payee_count
1324: (pact_id varchar2) IS
1325: SELECT count(paa.assignment_Action_id)
1326: FROM pay_assignment_actions paa
1327: WHERE paa.payroll_action_id = to_number(pact_id);
1328:
1329: BEGIN
1330: -- hr_utility.trace_on(NULL,'oracle');