APPS.PAY_CA_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 696: from ff_archive_items fai,

692: order by ppa.effective_date desc;
693:
694: cursor cur_dates (b_assignment_action_id number) is
695: select fnd_date.canonical_to_date(fai.value)
696: from ff_archive_items fai,
697: ff_database_items fdi
698: where fai.user_entity_id = fdi.user_entity_id
699: and fdi.user_name = 'ROE_DATE'
700: and fai.context1 = to_char(b_assignment_action_id);

Line 825: from ff_archive_items fai,

821: declare
822:
823: cursor cur_archive_value is
824: select fai.value
825: from ff_archive_items fai,
826: ff_database_items fdi
827: where fdi.user_name = p_user_name
828: and fdi.user_entity_id = fai.user_entity_id
829: and fai.context1 = p_assactid;

Line 831: l_value ff_archive_items.value%type;

827: where fdi.user_name = p_user_name
828: and fdi.user_entity_id = fai.user_entity_id
829: and fai.context1 = p_assactid;
830:
831: l_value ff_archive_items.value%type;
832:
833: begin
834:
835: open cur_archive_value;

Line 989: l_value ff_archive_items.value%type;

985:
986: l_lockingactid number;
987: l_assignment_id number;
988: l_tax_unit_id number;
989: l_value ff_archive_items.value%type;
990: l_user_entity_id ff_user_entities.user_entity_id%type;
991: l_archive_item_id ff_archive_items.archive_item_id%type;
992: l_object_version_number number(9);
993: l_some_warning boolean;

Line 991: l_archive_item_id ff_archive_items.archive_item_id%type;

987: l_assignment_id number;
988: l_tax_unit_id number;
989: l_value ff_archive_items.value%type;
990: l_user_entity_id ff_user_entities.user_entity_id%type;
991: l_archive_item_id ff_archive_items.archive_item_id%type;
992: l_object_version_number number(9);
993: l_some_warning boolean;
994: l_prev_roe_date date;
995: l_roe_date date;

Line 1082: ff_archive_items fai1,

1078: paa.assignment_action_id locked_action_id
1079: from
1080: pay_payroll_actions ppa,
1081: pay_assignment_actions paa,
1082: ff_archive_items fai1,
1083: ff_archive_items fai2
1084: where
1085: ppa.report_type = 'ROE' and
1086: ppa.report_category = 'ROEC' and

Line 1083: ff_archive_items fai2

1079: from
1080: pay_payroll_actions ppa,
1081: pay_assignment_actions paa,
1082: ff_archive_items fai1,
1083: ff_archive_items fai2
1084: where
1085: ppa.report_type = 'ROE' and
1086: ppa.report_category = 'ROEC' and
1087: ppa.report_qualifier = 'ROEQ' and

Line 1655: ff_archive_items fai1,

1651: fai2.value
1652: from
1653: pay_payroll_actions ppa,
1654: pay_assignment_actions paa,
1655: ff_archive_items fai1,
1656: ff_archive_items fai2
1657: where
1658: ppa.report_type = 'ROE' and
1659: ppa.report_category = 'ROEC' and

Line 1656: ff_archive_items fai2

1652: from
1653: pay_payroll_actions ppa,
1654: pay_assignment_actions paa,
1655: ff_archive_items fai1,
1656: ff_archive_items fai2
1657: where
1658: ppa.report_type = 'ROE' and
1659: ppa.report_category = 'ROEC' and
1660: ppa.report_qualifier = 'ROEQ' and

Line 1671: l_value ff_archive_items.value%TYPE;

1667: fai1.context1 = fai2.context1 and
1668: fai2.user_entity_id = l_edor_uid;
1669:
1670:
1671: l_value ff_archive_items.value%TYPE;
1672: l_temp_date date;
1673:
1674: begin
1675:

Line 2055: l_value ff_archive_items.value%type;

2051: and ppa.payroll_id = l_payroll_id
2052: and paa.tax_unit_id = l_tax_unit_id;
2053:
2054:
2055: l_value ff_archive_items.value%type;
2056: l_user_entity_id ff_user_entities.user_entity_id%type;
2057: l_archive_item_id ff_archive_items.archive_item_id%type;
2058: l_object_version_number number(9);
2059: l_some_warning boolean;

Line 2057: l_archive_item_id ff_archive_items.archive_item_id%type;

2053:
2054:
2055: l_value ff_archive_items.value%type;
2056: l_user_entity_id ff_user_entities.user_entity_id%type;
2057: l_archive_item_id ff_archive_items.archive_item_id%type;
2058: l_object_version_number number(9);
2059: l_some_warning boolean;
2060:
2061: l_prev_roe_date date;