APPS.PAY_CA_T4_CANCEL_MAG dependencies on FF_DATABASE_ITEMS

Line 145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;

141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;
145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
146: lv_flag_count NUMBER := 0;
147: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
148: l_payroll_act NUMBER;
149:

Line 464: ff_database_items fdi

460: CURSOR cur_archive (b_context_id IN NUMBER,
461: b_user_name VARCHAR2) IS
462: SELECT fai.value
463: FROM ff_archive_items fai,
464: ff_database_items fdi
465: WHERE fai.user_entity_id = fdi.user_entity_id
466: AND fai.context1 = b_context_id
467: AND fdi.user_name = b_user_name;
468:

Line 1183: lv_year ff_database_items.user_entity_id%TYPE := '0'; -- bug 13087483

1179: l_T4Slip_xml_string VARCHAR2(32000);
1180: l_T4_AMT_xml_string VARCHAR2(32000);
1181: l_all_final_xml_string VARCHAR2(32000);
1182: -- l_all_oth_info_xml_string VARCHAR2(32000);
1183: lv_year ff_database_items.user_entity_id%TYPE := '0'; -- bug 13087483
1184:
1185: TYPE other_info_xml_string IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER;
1186: l_other_info_xml_string other_info_xml_string;
1187:

Line 1258: ff_database_items fdi

1254: SELECT
1255: count(1)
1256: FROM
1257: ff_archive_items fai,
1258: ff_database_items fdi
1259: WHERE fai.context1 = p_aa_id
1260: AND fai.user_entity_id = fdi.user_entity_id
1261: AND fdi.user_name='CAEOY_PROVINCE_OF_EMPLOYMENT';
1262: ----

Line 1299: ff_database_items fdi

1295: SELECT
1296: fai.value
1297: FROM
1298: ff_archive_items fai,
1299: ff_database_items fdi
1300: WHERE fai.context1 = p_arch_action_id
1301: AND fai.user_entity_id = fdi.user_entity_id
1302: AND fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
1303: ----

Line 1309: ff_database_items fdi,

1305: SELECT
1306: fac.context
1307: FROM
1308: ff_archive_items fai,
1309: ff_database_items fdi,
1310: ff_archive_item_contexts fac,
1311: ff_contexts ffc
1312: WHERE fai.context1 = p_arch_action_id
1313: AND fai.archive_item_id = fac.archive_item_id