APPS.PAY_US_SQWL_UDF dependencies on FF_DATABASE_ITEMS

Line 984: l_user_entity_id ff_database_items.user_entity_id%TYPE;

980: FUNCTION get_ar_out_of_state_code (p_assignment_action_id number)
981: RETURN varchar2 IS
982:
983: l_ar_out_of_state_code ff_archive_items.value%TYPE;
984: l_user_entity_id ff_database_items.user_entity_id%TYPE;
985:
986: CURSOR get_user_entity_id (p_dbi_name IN VARCHAR2)
987: IS
988: SELECT user_entity_id

Line 989: FROM ff_database_items

985:
986: CURSOR get_user_entity_id (p_dbi_name IN VARCHAR2)
987: IS
988: SELECT user_entity_id
989: FROM ff_database_items
990: WHERE user_name = p_dbi_name;
991:
992: CURSOR get_archive_data (p_assignment_action_id IN NUMBER,
993: p_user_entity_id IN NUMBER)

Line 1083: ff_database_items fdi,

1079: from pay_payroll_actions ppa,
1080: pay_assignment_actions paa,
1081: ff_archive_items fai,
1082: ff_archive_items fai1,
1083: ff_database_items fdi,
1084: ff_database_items fdi1
1085: where ppa.payroll_action_id = p_payroll_action_id
1086: and ppa.payroll_action_id = paa.payroll_action_id
1087: and fai.context1 = paa.assignment_action_id

Line 1084: ff_database_items fdi1

1080: pay_assignment_actions paa,
1081: ff_archive_items fai,
1082: ff_archive_items fai1,
1083: ff_database_items fdi,
1084: ff_database_items fdi1
1085: where ppa.payroll_action_id = p_payroll_action_id
1086: and ppa.payroll_action_id = paa.payroll_action_id
1087: and fai.context1 = paa.assignment_action_id
1088: and fai.user_entity_id = fdi.user_entity_id

Line 1135: ff_database_items fdi,

1131: pay_assignment_actions paa,
1132: ff_archive_items fai,
1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1135: ff_database_items fdi,
1136: ff_database_items fdi1,
1137: ff_database_items fdi2
1138: where ppa.payroll_action_id = p_payroll_action_id
1139: and ppa.payroll_action_id = paa.payroll_action_id

Line 1136: ff_database_items fdi1,

1132: ff_archive_items fai,
1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1135: ff_database_items fdi,
1136: ff_database_items fdi1,
1137: ff_database_items fdi2
1138: where ppa.payroll_action_id = p_payroll_action_id
1139: and ppa.payroll_action_id = paa.payroll_action_id
1140: and paa.tax_unit_id = p_tax_unit_id

Line 1137: ff_database_items fdi2

1133: ff_archive_items fai1,
1134: ff_archive_items fai2,
1135: ff_database_items fdi,
1136: ff_database_items fdi1,
1137: ff_database_items fdi2
1138: where ppa.payroll_action_id = p_payroll_action_id
1139: and ppa.payroll_action_id = paa.payroll_action_id
1140: and paa.tax_unit_id = p_tax_unit_id
1141: and fai.context1 = paa.assignment_action_id

Line 1185: ff_database_items fdi,

1181: ff_archive_items fai,
1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,
1187: ff_database_items fdi2,
1188: ff_database_items fdi3
1189: where ppa.payroll_action_id = p_payroll_action_id

Line 1186: ff_database_items fdi1,

1182: ff_archive_items fai1,
1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,
1187: ff_database_items fdi2,
1188: ff_database_items fdi3
1189: where ppa.payroll_action_id = p_payroll_action_id
1190: and ppa.payroll_action_id = paa.payroll_action_id

Line 1187: ff_database_items fdi2,

1183: ff_archive_items fai2,
1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,
1187: ff_database_items fdi2,
1188: ff_database_items fdi3
1189: where ppa.payroll_action_id = p_payroll_action_id
1190: and ppa.payroll_action_id = paa.payroll_action_id
1191: and paa.tax_unit_id = p_tax_unit_id

Line 1188: ff_database_items fdi3

1184: ff_archive_items fai3,
1185: ff_database_items fdi,
1186: ff_database_items fdi1,
1187: ff_database_items fdi2,
1188: ff_database_items fdi3
1189: where ppa.payroll_action_id = p_payroll_action_id
1190: and ppa.payroll_action_id = paa.payroll_action_id
1191: and paa.tax_unit_id = p_tax_unit_id
1192: and fai.context1 = paa.assignment_action_id

Line 1241: ff_database_items fdi

1237: select paa.assignment_action_id paa_id, fdi.user_name dbi_name, nvl(fai.value, '0') value
1238: from pay_payroll_actions ppa,
1239: pay_assignment_actions paa,
1240: ff_archive_items fai,
1241: ff_database_items fdi
1242: where ppa.payroll_action_id = c_payroll_action_id --1436067
1243: and ppa.payroll_action_id = paa.payroll_action_id
1244: and paa.tax_unit_id = c_tax_unit_id --7896
1245: and fai.context1 = paa.assignment_action_id