APPS.PAY_US_1099R_MAG_REPORTING dependencies on FF_ARCHIVE_ITEMS

Line 140: token_val ff_archive_items.value%type;

136: parameter_list varchar2) return varchar2
137: is
138: start_ptr number;
139: end_ptr number;
140: token_val ff_archive_items.value%type;
141: par_value ff_archive_items.value%type;
142: begin
143: --
144: token_val := name||'=';

Line 141: par_value ff_archive_items.value%type;

137: is
138: start_ptr number;
139: end_ptr number;
140: token_val ff_archive_items.value%type;
141: par_value ff_archive_items.value%type;
142: begin
143: --
144: token_val := name||'=';
145: --

Line 990: ff_archive_items ffai,

986: and to_char(paa.tax_unit_id) in (
987: select ffaic2.context
988: from ff_contexts ffc,
989: ff_user_entities ffue,
990: ff_archive_items ffai,
991: ff_archive_items ffai2,
992: ff_archive_item_contexts ffaic,
993: ff_archive_item_contexts ffaic2,
994: ff_contexts ffc2

Line 991: ff_archive_items ffai2,

987: select ffaic2.context
988: from ff_contexts ffc,
989: ff_user_entities ffue,
990: ff_archive_items ffai,
991: ff_archive_items ffai2,
992: ff_archive_item_contexts ffaic,
993: ff_archive_item_contexts ffaic2,
994: ff_contexts ffc2
995: where ffai.context1 = cp_yrend_ppa_id

Line 1048: ff_archive_items ffai,

1044: and to_char(psv.tax_unit_id) in
1045: (select ffaic2.context
1046: from ff_contexts ffc,
1047: ff_user_entities ffue,
1048: ff_archive_items ffai,
1049: ff_archive_items ffai2,
1050: ff_archive_item_contexts ffaic,
1051: ff_archive_item_contexts ffaic2,
1052: ff_contexts ffc2

Line 1049: ff_archive_items ffai2,

1045: (select ffaic2.context
1046: from ff_contexts ffc,
1047: ff_user_entities ffue,
1048: ff_archive_items ffai,
1049: ff_archive_items ffai2,
1050: ff_archive_item_contexts ffaic,
1051: ff_archive_item_contexts ffaic2,
1052: ff_contexts ffc2
1053: where ffai.context1 = cp_yrend_ppa_id