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 989: ff_archive_items ffai,

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

Line 990: ff_archive_items ffai2,

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

Line 1046: ff_archive_items ffai,

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

Line 1047: ff_archive_items ffai2,

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