APPS.PAY_CA_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 700: from ff_archive_items fai,

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

Line 829: from ff_archive_items fai,

825: declare
826:
827: cursor cur_archive_value is
828: select fai.value
829: from ff_archive_items fai,
830: ff_database_items fdi
831: where fdi.user_name = p_user_name
832: and fdi.user_entity_id = fai.user_entity_id
833: and fai.context1 = p_assactid;

Line 835: l_value ff_archive_items.value%type;

831: where fdi.user_name = p_user_name
832: and fdi.user_entity_id = fai.user_entity_id
833: and fai.context1 = p_assactid;
834:
835: l_value ff_archive_items.value%type;
836:
837: begin
838:
839: open cur_archive_value;

Line 993: l_value ff_archive_items.value%type;

989:
990: l_lockingactid number;
991: l_assignment_id number;
992: l_tax_unit_id number;
993: l_value ff_archive_items.value%type;
994: l_user_entity_id ff_user_entities.user_entity_id%type;
995: l_archive_item_id ff_archive_items.archive_item_id%type;
996: l_object_version_number number(9);
997: l_some_warning boolean;

Line 995: l_archive_item_id ff_archive_items.archive_item_id%type;

991: l_assignment_id number;
992: l_tax_unit_id number;
993: l_value ff_archive_items.value%type;
994: l_user_entity_id ff_user_entities.user_entity_id%type;
995: l_archive_item_id ff_archive_items.archive_item_id%type;
996: l_object_version_number number(9);
997: l_some_warning boolean;
998: l_prev_roe_date date;
999: l_roe_date date;

Line 1086: ff_archive_items fai1,

1082: paa.assignment_action_id locked_action_id
1083: from
1084: pay_payroll_actions ppa,
1085: pay_assignment_actions paa,
1086: ff_archive_items fai1,
1087: ff_archive_items fai2
1088: where
1089: ppa.report_type = 'ROE' and
1090: ppa.report_category = 'ROEC' and

Line 1087: ff_archive_items fai2

1083: from
1084: pay_payroll_actions ppa,
1085: pay_assignment_actions paa,
1086: ff_archive_items fai1,
1087: ff_archive_items fai2
1088: where
1089: ppa.report_type = 'ROE' and
1090: ppa.report_category = 'ROEC' and
1091: ppa.report_qualifier = 'ROEQ' and

Line 1659: ff_archive_items fai1,

1655: fai2.value
1656: from
1657: pay_payroll_actions ppa,
1658: pay_assignment_actions paa,
1659: ff_archive_items fai1,
1660: ff_archive_items fai2
1661: where
1662: ppa.report_type = 'ROE' and
1663: ppa.report_category = 'ROEC' and

Line 1660: ff_archive_items fai2

1656: from
1657: pay_payroll_actions ppa,
1658: pay_assignment_actions paa,
1659: ff_archive_items fai1,
1660: ff_archive_items fai2
1661: where
1662: ppa.report_type = 'ROE' and
1663: ppa.report_category = 'ROEC' and
1664: ppa.report_qualifier = 'ROEQ' and

Line 1675: l_value ff_archive_items.value%TYPE;

1671: fai1.context1 = fai2.context1 and
1672: fai2.user_entity_id = l_edor_uid;
1673:
1674:
1675: l_value ff_archive_items.value%TYPE;
1676: l_temp_date date;
1677:
1678: begin
1679:

Line 2059: l_value ff_archive_items.value%type;

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

Line 2061: l_archive_item_id ff_archive_items.archive_item_id%type;

2057:
2058:
2059: l_value ff_archive_items.value%type;
2060: l_user_entity_id ff_user_entities.user_entity_id%type;
2061: l_archive_item_id ff_archive_items.archive_item_id%type;
2062: l_object_version_number number(9);
2063: l_some_warning boolean;
2064:
2065: l_prev_roe_date date;