APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 810: per_cagr_entitlement_items cei

806: Cursor csr_entitlement_items(p_assignment_id NUMBER,
807: p_element_type_id NUMBER) IS
808: select cer.cagr_entitlement_item_id
809: from per_cagr_entitlement_results cer,
810: per_cagr_entitlement_items cei
811: where cer.assignment_id = p_assignment_id
812: and cer.element_type_id = p_element_type_id
813: and cer.cagr_entitlement_item_id = cei.cagr_entitlement_item_id
814: and nvl(cei.auto_create_entries_flag,'N') = 'Y'

Line 834: FROM per_cagr_entitlement_results cer,PER_CAGR_ENTITLEMENT_ITEMS cei

830: AND ASSIGNMENT_ID = p_assignment_id);
831:
832: CURSOR csr_entitlement_element_detail(p_entitlement_id number, p_assignment_id number) IS
833: SELECT cei.element_type_id,cer.start_date,cer.end_date
834: FROM per_cagr_entitlement_results cer,PER_CAGR_ENTITLEMENT_ITEMS cei
835: WHERE cer.ASSIGNMENT_ID = p_assignment_id
836: AND cer.end_date = trunc(p_params.effective_date)-1
837: AND cer.cagr_entitlement_item_id=cei.cagr_entitlement_item_id
838: AND cei.cagr_entitlement_item_id = p_entitlement_id;

Line 851: l_entitlement_id per_cagr_entitlement_items.cagr_entitlement_item_id%type;

847:
848: l_element_type_id NUMBER(15);
849: l_start_date DATE;
850: l_end_date DATE;
851: l_entitlement_id per_cagr_entitlement_items.cagr_entitlement_item_id%type;
852: --fix for bug 5557658 ends here.
853:
854: l_mapping_table t_mapping_table;
855: l_proc constant VARCHAR2(80) := g_pkg || 'call_PAY_api';

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

1303: l_PAY_results t_PAY_results;
1304:
1305: l_proc constant VARCHAR2(80) := g_pkg || 'do_apply_for_assignment';
1306: l_table_counter NUMBER(15) := 0;
1307: l_old_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE := 0;
1308: l_old_element_type_id per_cagr_entitlement_items.element_type_id%TYPE := 0;
1309:
1310:
1311: BEGIN

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

1304:
1305: l_proc constant VARCHAR2(80) := g_pkg || 'do_apply_for_assignment';
1306: l_table_counter NUMBER(15) := 0;
1307: l_old_cagr_api_id per_cagr_entitlement_items.cagr_api_id%TYPE := 0;
1308: l_old_element_type_id per_cagr_entitlement_items.element_type_id%TYPE := 0;
1309:
1310:
1311: BEGIN
1312: