eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 329: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table

325: AND business_group_id=p_business_group_id; --New business group specific Condition is added in this cursor for bug 6856733
326:
327: --6666135 End
328:
329: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table
330: CURSOR c_pqp_assignment(n_assignment_id NUMBER)
331: IS
332: SELECT pqpaaf.lgps_process_flag,
333: pqpaaf.assignment_attribute_id,

Line 336: FROM pqp_assignment_attributes_f pqpaaf

332: SELECT pqpaaf.lgps_process_flag,
333: pqpaaf.assignment_attribute_id,
334: pqpaaf.EFFECTIVE_START_DATE,
335: pqpaaf.object_version_number
336: FROM pqp_assignment_attributes_f pqpaaf
337: WHERE pqpaaf.assignment_id = n_assignment_id
338: AND pqpaaf.business_group_id = p_business_group_id
339: AND nvl(pqpaaf.lgps_process_flag,'Nul') = nvl(l_mode,nvl(pqpaaf.lgps_process_flag,'Nul')) --l_mode will have value only in case of Incomplete and reprocess
340: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE

Line 341: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id

337: WHERE pqpaaf.assignment_id = n_assignment_id
338: AND pqpaaf.business_group_id = p_business_group_id
339: AND nvl(pqpaaf.lgps_process_flag,'Nul') = nvl(l_mode,nvl(pqpaaf.lgps_process_flag,'Nul')) --l_mode will have value only in case of Incomplete and reprocess
340: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE
341: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id
342: AND lgps_process_flag = nvl(l_mode,lgps_process_flag) AND business_group_id = p_business_group_id
343: AND EFFECTIVE_START_DATE BETWEEN v_assignment_eff_date AND v_eff_end_date));
344:
345: --This cursor will fetch the all elements for the assigment

Line 379: --This cursor to check the future date track records in pqp_assignment_attributes_f

375: WHERE pet.element_type_id = n_element_type_id
376: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
377:
378:
379: --This cursor to check the future date track records in pqp_assignment_attributes_f
380: CURSOR c_future_date(n_assignment_id NUMBER)
381: IS
382: SELECT max(EFFECTIVE_START_DATE)
383: FROM pqp_assignment_attributes_f pqpaaf

Line 383: FROM pqp_assignment_attributes_f pqpaaf

379: --This cursor to check the future date track records in pqp_assignment_attributes_f
380: CURSOR c_future_date(n_assignment_id NUMBER)
381: IS
382: SELECT max(EFFECTIVE_START_DATE)
383: FROM pqp_assignment_attributes_f pqpaaf
384: WHERE pqpaaf.assignment_id = n_assignment_id
385: AND pqpaaf.business_group_id = p_business_group_id;
386: --
387: --This cursor to correct the entries till the end date

Line 391: FROM pqp_assignment_attributes_f pqpaaf

387: --This cursor to correct the entries till the end date
388: CURSOR c_correct_pqp(n_assignment_id NUMBER)
389: IS
390: SELECT ASSIGNMENT_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, object_version_number
391: FROM pqp_assignment_attributes_f pqpaaf
392: WHERE pqpaaf.assignment_id = n_assignment_id
393: and pqpaaf.business_group_id = p_business_group_id
394: and pqpaaf.EFFECTIVE_START_DATE > v_max_date
395: -- and pqpaaf.EFFECTIVE_START_DATE between v_eff_start_date and v_eff_end_date_corr;

Line 411: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;

407: n_present number;
408: b_rate_type boolean;
409: b_element_present boolean;
410: b_input_value_present boolean;
411: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
412: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
413: l_lgps_pensionable_pay number;
414: b_pqp_assignment_found boolean;
415: b_pqp_found boolean;

Line 412: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;

408: b_rate_type boolean;
409: b_element_present boolean;
410: b_input_value_present boolean;
411: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
412: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
413: l_lgps_pensionable_pay number;
414: b_pqp_assignment_found boolean;
415: b_pqp_found boolean;
416: c_pqp_assignment_row c_pqp_assignment%rowtype;

Line 595: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.

591: END IF;
592: END IF;
593:
594: IF b_pqp_assignment_found is NULL AND l_mode is not null THEN
595: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.
596: raise skip_assignment;
597: END IF;
598:
599: OPEN c1_all_element(c_all_assignments.assignment_id);

Line 743: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';

739: END IF;
740: ----------
741: ELSE
742: IF l_mode is null then
743: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
744: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
745: END IF;
746: raise skip_assignment;
747: END IF; --b_pqp_assignment_found

Line 964: FROM pqp_assignment_attributes_f pqaaf

960: v_trans_flag varchar2(30);
961: CURSOR C_Transtional_Flag
962: IS
963: SELECT LGPS_TRANS_ARRANG_FLAG
964: FROM pqp_assignment_attributes_f pqaaf
965: WHERE pqaaf.assignment_id = p_assignment_id
966: AND pqaaf.business_group_id = p_business_group_id
967: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
968: BEGIN

Line 980: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;

976: p_effective_date Date,
977: p_business_group_id NUMBER)
978: RETURN number
979: IS
980: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
981: CURSOR c_pension_pay
982: IS
983: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
984: FROM pqp_assignment_attributes_f pqaaf

Line 984: FROM pqp_assignment_attributes_f pqaaf

980: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
981: CURSOR c_pension_pay
982: IS
983: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
984: FROM pqp_assignment_attributes_f pqaaf
985: WHERE pqaaf.assignment_id = p_assignment_id
986: AND pqaaf.business_group_id = p_business_group_id
987: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
988: BEGIN