APPS.PAY_CA_T4_AMEND_MAG dependencies on FF_DATABASE_ITEMS

Line 8: l_tax_year_ue_id ff_database_items.user_entity_id%TYPE;

4: PROCEDURE range_cursor (
5: p_pactid IN NUMBER,
6: p_sqlstr OUT NOCOPY VARCHAR2)
7: IS
8: l_tax_year_ue_id ff_database_items.user_entity_id%TYPE;
9: l_person_id_ue_id ff_database_items.user_entity_id%TYPE;
10: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
11: l_tax_year pay_payroll_actions.legislative_parameters%TYPE;
12: BEGIN

Line 9: l_person_id_ue_id ff_database_items.user_entity_id%TYPE;

5: p_pactid IN NUMBER,
6: p_sqlstr OUT NOCOPY VARCHAR2)
7: IS
8: l_tax_year_ue_id ff_database_items.user_entity_id%TYPE;
9: l_person_id_ue_id ff_database_items.user_entity_id%TYPE;
10: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
11: l_tax_year pay_payroll_actions.legislative_parameters%TYPE;
12: BEGIN
13:

Line 23: FROM ff_database_items

19: l_legislative_parameters);
20: --
21: SELECT user_entity_id
22: INTO l_tax_year_ue_id
23: FROM ff_database_items
24: WHERE user_name='CAEOY_TAXATION_YEAR';
25: --
26: SELECT user_entity_id
27: INTO l_person_id_ue_id

Line 28: FROM ff_database_items

24: WHERE user_name='CAEOY_TAXATION_YEAR';
25: --
26: SELECT user_entity_id
27: INTO l_person_id_ue_id
28: FROM ff_database_items
29: WHERE user_name='CAEOY_PERSON_ID';
30: --
31: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
32: FROM ff_archive_items fai1,

Line 165: FROM ff_database_items

161: AND user_entity_id = cp_uid_t4amend_flag;
162: -----
163: CURSOR c_get_ue_id(cp_user_name IN VARCHAR2) IS
164: SELECT user_entity_id
165: FROM ff_database_items
166: WHERE user_name = cp_user_name;
167: -----
168: CURSOR c_lockingactid_check (cp_locking_asg_act_id IN NUMBER) IS
169: SELECT assignment_action_id

Line 185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;

181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;
185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
186: lv_flag_count NUMBER := 0;
187: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
188:
189: BEGIN

Line 536: ff_database_items fdi

532: CURSOR cur_archive (b_context_id IN NUMBER,
533: b_user_name VARCHAR2) IS
534: SELECT fai.value
535: FROM ff_archive_items fai,
536: ff_database_items fdi
537: WHERE fai.user_entity_id = fdi.user_entity_id
538: AND fai.context1 = b_context_id
539: AND fdi.user_name = b_user_name;
540:

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

1233: l_T4Slip_xml_string VARCHAR2(32000);
1234: l_T4_AMT_xml_string VARCHAR2(32000);
1235: l_all_final_xml_string VARCHAR2(32000);
1236: -- l_all_oth_info_xml_string VARCHAR2(32000);
1237: lv_year ff_database_items.user_entity_id%TYPE := '0'; -- bug 13087483
1238:
1239: TYPE other_info_xml_string IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER;
1240: l_other_info_xml_string other_info_xml_string;
1241:

Line 1310: ff_database_items fdi

1306: SELECT
1307: count(1)
1308: FROM
1309: ff_archive_items fai,
1310: ff_database_items fdi
1311: WHERE fai.context1 = p_aa_id
1312: AND fai.user_entity_id = fdi.user_entity_id
1313: AND fdi.user_name='CAEOY_PROVINCE_OF_EMPLOYMENT';
1314: ----

Line 1342: ff_database_items fdi,

1338: SELECT
1339: fac.context
1340: FROM
1341: ff_archive_items fai,
1342: ff_database_items fdi,
1343: ff_archive_item_contexts fac,
1344: ff_contexts ffc
1345: WHERE fai.context1 = p_arch_action_id
1346: AND fai.archive_item_id = fac.archive_item_id