DBA Data[Home] [Help]

APPS.PAY_US_SQWL_MISC dependencies on FF_ARCHIVE_ITEMS

Line 44: from ff_archive_items fai,

40:
41:
42: cursor c_old_month3(p_asact_ctx_id in number) is
43: select value
44: from ff_archive_items fai,
45: ff_user_entities fue
46: where context1 = p_asact_ctx_id
47: and fue.user_entity_id = fai.user_entity_id
48: and fue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_3';

Line 83: from ff_archive_items fai,

79:
80:
81: cursor c_old_month2(p_asact_ctx_id in number) is
82: select value
83: from ff_archive_items fai,
84: ff_user_entities fue
85: where context1 = p_asact_ctx_id
86: and fue.user_entity_id = fai.user_entity_id
87: and fue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_2';

Line 122: from ff_archive_items fai,

118:
119:
120: cursor c_old_month1(p_asact_ctx_id in number) is
121: select value
122: from ff_archive_items fai,
123: ff_user_entities fue
124: where context1 = p_asact_ctx_id
125: and fue.user_entity_id = fai.user_entity_id
126: and fue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_1';