eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_USER_ENTITIES

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

33: g_package constant varchar2(30) := 'pay_au_payment_summary_amend';
34: g_legislation_code constant varchar2(2) := 'AU';
35:
36:
37: TYPE char_tab_type IS TABLE OF ff_user_entities.user_entity_name%TYPE;
38:
39: /* The following global tables store the User entity type of each DB Item */
40:
41: g_payg_db_items char_tab_type;

Line 765: FROM ff_user_entities

761:
762: CURSOR csr_payg_items
763: IS
764: SELECT user_entity_name
765: FROM ff_user_entities
766: WHERE legislation_code = 'AU'
767: AND ( user_entity_name LIKE 'X_ALLOWANCE%'
768: OR user_entity_name LIKE 'X_EMPLOYEE%DATE%'
769: OR user_entity_name LIKE 'X_UNION%'

Line 784: FROM ff_user_entities

780: /* start bug 14703826 - Modifed to check new ETP balances */
781: CURSOR csr_etp1_items
782: IS
783: SELECT user_entity_name
784: FROM ff_user_entities
785: WHERE legislation_code = 'AU'
786: AND ( user_entity_name IN ( 'X_ETP_DED_EXCL_ASG_YTD','X_INV_PAY_EXCL_ASG_YTD'
787: ,'X_POST_JUN_83_TAXED_EXCL_ASG_YTD','X_PRE_JUL_83_COMP_EXCL_ASG_YTD')
788: OR user_entity_name LIKE 'X%EXCL%' )

Line 796: FROM ff_user_entities

792:
793: CURSOR csr_etp2_items
794: IS
795: SELECT user_entity_name
796: FROM ff_user_entities
797: WHERE legislation_code = 'AU'
798: AND ( user_entity_name IN ( 'X_ETP_DED_EXCL_PP_ASG_YTD','X_INV_PAY_EXCL_PP_ASG_YTD'
799: ,'X_POST_JUN_83_TAXED_EXCL_PP_ASG_YTD','X_PRE_JUL_83_COMP_EXCL_PP_ASG_YTD')
800: OR user_entity_name LIKE 'X%EXCL_PP%')

Line 807: FROM ff_user_entities

803:
804: CURSOR csr_etp3_items
805: IS
806: SELECT user_entity_name
807: FROM ff_user_entities
808: WHERE legislation_code = 'AU'
809: AND ( user_entity_name IN ( 'X_ETP_DED_NON_EXCL_ASG_YTD',
810: 'X_POST_JUN_83_TAXED_NON_EXCL_ASG_YTD','X_PRE_JUL_83_COMP_NON_EXCL_ASG_YTD')
811: OR user_entity_name LIKE 'X%\_NE\_%' escape '\')

Line 818: FROM ff_user_entities

814:
815: CURSOR csr_etp4_items
816: IS
817: SELECT user_entity_name
818: FROM ff_user_entities
819: WHERE legislation_code = 'AU'
820: AND ( user_entity_name IN ( 'X_ETP_DED_NOT_TRANS_NOT_PPTERM_ASG_YTD'
821: ,'X_POST_JUN_83_TAXED_NON_EXCL_PP_ASG_YTD','X_PRE_JUL_83_COMP_NON_EXCL_PP_ASG_YTD')
822: OR user_entity_name LIKE 'X%\_NE\_PP%' escape '\' )

Line 833: FROM ff_user_entities

829:
830: CURSOR csr_etp_cmn_items
831: IS
832: SELECT user_entity_name
833: FROM ff_user_entities
834: WHERE legislation_code = 'AU'
835: AND ( user_entity_name LIKE 'X_ETP%DATE'
836: OR user_entity_name LIKE 'X_DAYS%'
837: OR user_entity_name IN ('X_ETP_TAX_FILE_NUMBER')

Line 847: FROM ff_user_entities

843: /*bug9147430 Added new cursors for FW */
844: CURSOR csr_fw1_payg_items
845: IS
846: SELECT user_entity_name
847: FROM ff_user_entities
848: WHERE legislation_code = 'AU'
849: AND user_entity_name LIKE 'X_FW1%';
850:
851: CURSOR csr_fw2_payg_items

Line 854: FROM ff_user_entities

850:
851: CURSOR csr_fw2_payg_items
852: IS
853: SELECT user_entity_name
854: FROM ff_user_entities
855: WHERE legislation_code = 'AU'
856: AND user_entity_name LIKE 'X_FW2%';
857:
858:

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

927:
928: /* Bug 9817894 - Modifed function such that X_PRE_JUL_83_COMPONENT_ASG_YTD,X_POST_JUN_83_TAXED_ASG_YTD,X_POST_JUN_83_UNTAXED_ASG_YTD
929: user entities will be returned under ETP_CMN_BAL data file record */
930:
931: FUNCTION check_user_entity_type(p_user_entity_name IN ff_user_entities.user_entity_name%TYPE)
932: RETURN VARCHAR2
933: IS
934:
935:

Line 939: l_entity_id ff_user_entities.user_entity_id%TYPE;

935:
936: l_return_value VARCHAR2(20);
937: l_procedure VARCHAR2(80);
938:
939: l_entity_id ff_user_entities.user_entity_id%TYPE;
940: l_found BOOLEAN;
941:
942: BEGIN
943:

Line 1099: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE

1095: --------------------------------------------------------------------
1096: */
1097:
1098: FUNCTION compare_user_entity_value
1099: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
1100: ,p_value1 IN ff_archive_items.value%TYPE
1101: ,p_value2 IN ff_archive_items.value%TYPE
1102: ,p_data_type IN ff_database_items.data_type%TYPE)
1103: RETURN VARCHAR2

Line 1178: ff_user_entities fue

1174: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)
1175: IS
1176: SELECT fue.user_entity_name
1177: FROM ff_archive_items fae,
1178: ff_user_entities fue
1179: WHERE fae.context1 = c_archive_action_id
1180: AND fue.user_entity_id = fae.user_entity_id
1181: AND (
1182: fue.user_entity_name LIKE 'X_ALLOWANCE%'

Line 1328: ff_user_entities fue,

1324: IS
1325: SELECT fai.value
1326: ,fdi.data_type
1327: FROM ff_archive_items fai,
1328: ff_user_entities fue,
1329: ff_database_items fdi
1330: WHERE fai.context1 = c_assignment_action_id
1331: AND fai.user_entity_id = fue.user_entity_id
1332: AND fdi.user_entity_id = fue.user_entity_id

Line 1349: FROM ff_user_entities fue,

1345: /*bug9147430*/
1346: CURSOR csr_data_type(c_user_entity_name VARCHAR2)
1347: IS
1348: SELECT fdi.data_type
1349: FROM ff_user_entities fue,
1350: ff_database_items fdi
1351: WHERE fdi.user_entity_id = fue.user_entity_id
1352: AND fue.user_entity_name = c_user_entity_name;
1353:

Line 2078: FROM ff_user_entities fue

2074: CURSOR get_user_entity_id(c_user_entity_name IN VARCHAR2)
2075: IS
2076: SELECT fue.user_entity_id
2077: ,dbi.data_type
2078: FROM ff_user_entities fue
2079: ,ff_database_items dbi
2080: WHERE user_entity_name = c_user_entity_name
2081: AND fue.user_entity_id = dbi.user_entity_id
2082: AND fue.legislation_code = 'AU';

Line 2085: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

2081: AND fue.user_entity_id = dbi.user_entity_id
2082: AND fue.legislation_code = 'AU';
2083:
2084: l_procedure VARCHAR2(80);
2085: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
2086: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
2087: l_object_version_number ff_archive_items.object_version_number%type;
2088: l_some_warning boolean;
2089:

Line 2216: ff_user_entities fue,

2212: ,c_context_id ff_contexts.context_id%TYPE)
2213: IS
2214: SELECT COUNT(*)
2215: FROM ff_archive_items fai,
2216: ff_user_entities fue,
2217: ff_archive_item_contexts faic
2218: WHERE fai.context1 = c_archive_action_id
2219: AND fue.user_entity_id = fai.user_entity_id
2220: AND fai.archive_item_id = faic.archive_item_id