APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 819: per_cagr_entitlement_items cei

815: Cursor csr_entitlement_items(p_assignment_id NUMBER,
816: p_element_type_id NUMBER) IS
817: select cer.cagr_entitlement_item_id
818: from per_cagr_entitlement_results cer,
819: per_cagr_entitlement_items cei
820: where cer.assignment_id = p_assignment_id
821: and cer.element_type_id = p_element_type_id
822: and cer.cagr_entitlement_item_id = cei.cagr_entitlement_item_id
823: and nvl(cei.auto_create_entries_flag,'N') = 'Y'

Line 843: FROM per_cagr_entitlement_results cer,PER_CAGR_ENTITLEMENT_ITEMS cei

839: AND ASSIGNMENT_ID = p_assignment_id);
840:
841: CURSOR csr_entitlement_element_detail(p_entitlement_id number, p_assignment_id number) IS
842: SELECT cei.element_type_id,cer.start_date,cer.end_date
843: FROM per_cagr_entitlement_results cer,PER_CAGR_ENTITLEMENT_ITEMS cei
844: WHERE cer.ASSIGNMENT_ID = p_assignment_id
845: AND cer.end_date = trunc(p_params.effective_date)-1
846: AND cer.cagr_entitlement_item_id=cei.cagr_entitlement_item_id
847: AND cei.cagr_entitlement_item_id = p_entitlement_id;

Line 861: l_entitlement_id per_cagr_entitlement_items.cagr_entitlement_item_id%type;

857:
858: l_element_type_id NUMBER(15);
859: l_start_date DATE;
860: l_end_date DATE;
861: l_entitlement_id per_cagr_entitlement_items.cagr_entitlement_item_id%type;
862: --fix for bug 5557658 ends here.
863:
864: l_mapping_table t_mapping_table;
865: l_proc constant VARCHAR2(80) := g_pkg || 'call_PAY_api';

Line 1318: l_old_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE := 0;

1314: l_PAY_results t_PAY_results;
1315:
1316: l_proc constant VARCHAR2(80) := g_pkg || 'do_apply_for_assignment';
1317: l_table_counter NUMBER(15) := 0;
1318: l_old_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE := 0;
1319: l_old_element_type_id per_cagr_entitlement_items.element_type_id%TYPE := 0;
1320:
1321:
1322: BEGIN

Line 1319: l_old_element_type_id per_cagr_entitlement_items.element_type_id%TYPE := 0;

1315:
1316: l_proc constant VARCHAR2(80) := g_pkg || 'do_apply_for_assignment';
1317: l_table_counter NUMBER(15) := 0;
1318: l_old_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE := 0;
1319: l_old_element_type_id per_cagr_entitlement_items.element_type_id%TYPE := 0;
1320:
1321:
1322: BEGIN
1323: