APPS.PAY_US_MAGW2_REPORTING dependencies on FF_DATABASE_ITEMS

Line 20: FROM ff_database_items DI,

16: ) RETURN NUMBER IS
17: -- Get the defined_balance_id for the specified balance DB item.
18: CURSOR csr_defined_balance IS
19: SELECT TO_NUMBER(UE.creator_id)
20: FROM ff_database_items DI,
21: ff_user_entities UE
22: WHERE DI.user_name = p_db_item_name
23: AND UE.user_entity_id = DI.user_entity_id
24: AND UE.creator_type = 'B'

Line 324: FROM ff_database_items fdi

320:
321: CURSOR c_user_entity_id_of_bal
322: IS
323: SELECT user_entity_id
324: FROM ff_database_items fdi
325: WHERE user_name = 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD' ;
326:
327:
328: /* cursor to get_context_of_tax_unit_id */

Line 391: ff_database_items fdi

387: ff_archive_item_contexts con2,
388: ff_contexts fc3,
389: ff_contexts fc2,
390: ff_archive_items target,
391: ff_database_items fdi
392: WHERE target.context1 = cp_payroll_action_id
393: /* context of payroll_action_id */
394: and fdi.user_name = 'A_FIPS_CODE_JD'
395: and target.user_entity_id = fdi.user_entity_id

Line 837: ff_database_items fdi,

833: SELECT DISTINCT
834: to_number(paa.serial_number)
835: FROM ff_archive_item_contexts faic,
836: ff_archive_items fai,
837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,
840: per_assignments_f paf,
841: pay_payroll_actions ppa1

Line 924: ff_database_items fdi,

920: paa.tax_unit_id,
921: faic.context , 2),0)
922: FROM ff_archive_item_contexts faic,
923: ff_archive_items fai,
924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: per_assignments_f paf,
928: pay_payroll_actions ppa1

Line 1007: ff_database_items fdi

1003: select to_number(fai.value)
1004: from ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_contexts fc,
1007: ff_database_items fdi
1008: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'
1009: and fc.context_name = 'TAX_UNIT_ID'
1010: and fai.context1 = p_assignment_action_id
1011: and fai.user_entity_id = fdi.user_entity_id