APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_USER_ENTITIES

Line 24: TYPE char_tab_type IS TABLE OF ff_user_entities.user_entity_name%TYPE;

20: g_package constant varchar2(30) := 'pay_au_payment_summary_amend';
21: g_legislation_code constant varchar2(2) := 'AU';
22:
23:
24: TYPE char_tab_type IS TABLE OF ff_user_entities.user_entity_name%TYPE;
25:
26: /* The following global tables store the User entity type of each DB Item */
27:
28: g_payg_db_items char_tab_type;

Line 406: FROM ff_user_entities

402:
403: CURSOR csr_payg_items
404: IS
405: SELECT user_entity_name
406: FROM ff_user_entities
407: WHERE legislation_code = 'AU'
408: AND ( user_entity_name LIKE 'X_ALLOWANCE%'
409: OR user_entity_name LIKE 'X_EMPLOYEE%DATE%'
410: OR user_entity_name LIKE 'X_UNION%'

Line 422: FROM ff_user_entities

418:
419: CURSOR csr_etp1_items
420: IS
421: SELECT user_entity_name
422: FROM ff_user_entities
423: WHERE legislation_code = 'AU'
424: AND user_entity_name IN
425: ( 'X_ETP_DED_TRANS_PPTERM_ASG_YTD','X_INV_PAY_TRANS_PPTERM_ASG_YTD'
426: ,'X_POST_JUN_83_TAXED_TRANS_PPTERM_ASG_YTD','X_PRE_JUL_83_COMP_TRANS_PPTERM_ASG_YTD');

Line 431: FROM ff_user_entities

427:
428: CURSOR csr_etp2_items
429: IS
430: SELECT user_entity_name
431: FROM ff_user_entities
432: WHERE legislation_code = 'AU'
433: AND user_entity_name IN
434: ( 'X_ETP_DED_TRANS_NOT_PPTERM_ASG_YTD','X_INV_PAY_TRANS_NOT_PPTERM_ASG_YTD'
435: ,'X_POST_JUN_83_TAXED_TRANS_NOT_PPTERM_ASG_YTD','X_PRE_JUL_83_COMP_TRANS_NOT_PPTERM_ASG_YTD');

Line 440: FROM ff_user_entities

436:
437: CURSOR csr_etp3_items
438: IS
439: SELECT user_entity_name
440: FROM ff_user_entities
441: WHERE legislation_code = 'AU'
442: AND user_entity_name IN
443: ( 'X_ETP_DED_NOT_TRANS_PPTERM_ASG_YTD','X_INV_PAY_NOT_TRANS_PPTERM_ASG_YTD'
444: ,'X_POST_JUN_83_TAXED_NOT_TRANS_PPTERM_ASG_YTD','X_PRE_JUL_83_COMP_NOT_TRANS_PPTERM_ASG_YTD');

Line 449: FROM ff_user_entities

445:
446: CURSOR csr_etp4_items
447: IS
448: SELECT user_entity_name
449: FROM ff_user_entities
450: WHERE legislation_code = 'AU'
451: AND user_entity_name IN
452: ( 'X_ETP_DED_NOT_TRANS_NOT_PPTERM_ASG_YTD','X_INV_PAY_NOT_TRANS_NOT_PPTERM_ASG_YTD'
453: ,'X_POST_JUN_83_TAXED_NOT_TRANS_NOT_PPTERM_ASG_YTD','X_PRE_JUL_83_COMP_NOT_TRANS_NOT_PPTERM_ASG_YTD');

Line 458: FROM ff_user_entities

454:
455: CURSOR csr_etp_cmn_items
456: IS
457: SELECT user_entity_name
458: FROM ff_user_entities
459: WHERE legislation_code = 'AU'
460: AND ( user_entity_name LIKE 'X_ETP%DATE%'
461: OR user_entity_name LIKE 'X_DAYS%'
462: OR user_entity_name IN ('X_ETP_TAX_FILE_NUMBER')

Line 526: FUNCTION check_user_entity_type(p_user_entity_name IN ff_user_entities.user_entity_name%TYPE)

522: CMN - Rest of the Items (Default Value returned)
523: --------------------------------------------------------------------
524: */
525:
526: FUNCTION check_user_entity_type(p_user_entity_name IN ff_user_entities.user_entity_name%TYPE)
527: RETURN VARCHAR2
528: IS
529:
530:

Line 534: l_entity_id ff_user_entities.user_entity_id%TYPE;

530:
531: l_return_value VARCHAR2(20);
532: l_procedure VARCHAR2(80);
533:
534: l_entity_id ff_user_entities.user_entity_id%TYPE;
535: l_found BOOLEAN;
536:
537: BEGIN
538:

Line 669: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE

665: --------------------------------------------------------------------
666: */
667:
668: FUNCTION compare_user_entity_value
669: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
670: ,p_value1 IN ff_archive_items.value%TYPE
671: ,p_value2 IN ff_archive_items.value%TYPE
672: ,p_data_type IN ff_database_items.data_type%TYPE)
673: RETURN VARCHAR2

Line 747: ff_user_entities fue

743: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)
744: IS
745: SELECT fue.user_entity_name
746: FROM ff_archive_items fae,
747: ff_user_entities fue
748: WHERE fae.context1 = c_archive_action_id
749: AND fue.user_entity_id = fae.user_entity_id
750: AND (
751: fue.user_entity_name LIKE 'X_ALLOWANCE%'

Line 895: ff_user_entities fue,

891: IS
892: SELECT fai.value
893: ,fdi.data_type
894: FROM ff_archive_items fai,
895: ff_user_entities fue,
896: ff_database_items fdi
897: WHERE fai.context1 = c_assignment_action_id
898: AND fai.user_entity_id = fue.user_entity_id
899: AND fdi.user_entity_id = fue.user_entity_id

Line 1364: FROM ff_user_entities fue

1360: CURSOR get_user_entity_id(c_user_entity_name IN VARCHAR2)
1361: IS
1362: SELECT fue.user_entity_id
1363: ,dbi.data_type
1364: FROM ff_user_entities fue
1365: ,ff_database_items dbi
1366: WHERE user_entity_name = c_user_entity_name
1367: AND fue.user_entity_id = dbi.user_entity_id
1368: AND fue.legislation_code = 'AU';

Line 1371: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

1367: AND fue.user_entity_id = dbi.user_entity_id
1368: AND fue.legislation_code = 'AU';
1369:
1370: l_procedure VARCHAR2(80);
1371: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
1372: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1373: l_object_version_number ff_archive_items.object_version_number%type;
1374: l_some_warning boolean;
1375:

Line 1501: ff_user_entities fue,

1497: ,c_context_id ff_contexts.context_id%TYPE)
1498: IS
1499: SELECT COUNT(*)
1500: FROM ff_archive_items fai,
1501: ff_user_entities fue,
1502: ff_archive_item_contexts faic
1503: WHERE fai.context1 = c_archive_action_id
1504: AND fue.user_entity_id = fai.user_entity_id
1505: AND fai.archive_item_id = faic.archive_item_id