DBA Data[Home] [Help]

APPS.PER_US_VETC_TAP dependencies on DUAL

Line 312: FROM dual

308: AND ass.organization_id IN
309: (
310: SELECT -- :establishment_id
311: to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID'))
312: FROM dual
313: UNION
314: SELECT ose.organization_id_child
315: FROM per_org_structure_elements ose
316: WHERE ose.org_structure_version_id + 0 =

Line 406: FROM dual

402: AND ass.organization_id IN
403: (
404: SELECT
405: to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID'))
406: FROM dual
407: UNION
408: SELECT ose.organization_id_child
409: FROM per_org_structure_elements ose
410: WHERE ose.org_structure_version_id + 0 =

Line 475: FROM dual

471: AND ass.organization_id IN
472: (
473: SELECT
474: to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID'))
475: FROM dual
476: UNION
477: SELECT ose.organization_id_child
478: FROM per_org_structure_elements ose
479: WHERE ose.org_structure_version_id + 0 =

Line 529: FROM dual

525: AND ass.organization_id IN
526: (
527: SELECT to_number(pay_magtape_generic.get_parameter_value(
528: 'TRANSFER_ESTABLISHMENT_ID'))
529: FROM dual
530: UNION
531: SELECT ose.organization_id_child
532: FROM per_org_structure_elements ose
533: WHERE ose.org_structure_version_id + 0 =