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 341: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table

337: AND business_group_id=p_business_group_id; --New business group specific Condition is added in this cursor for bug 6856733
338:
339: --6666135 End
340:
341: --This cursor will check for the presence of assignments in pqp_assignment_attributes_f table
342: CURSOR c_pqp_assignment(n_assignment_id NUMBER)
343: IS
344: SELECT pqpaaf.lgps_process_flag,
345: pqpaaf.assignment_attribute_id,

Line 348: FROM pqp_assignment_attributes_f pqpaaf

344: SELECT pqpaaf.lgps_process_flag,
345: pqpaaf.assignment_attribute_id,
346: pqpaaf.EFFECTIVE_START_DATE,
347: pqpaaf.object_version_number
348: FROM pqp_assignment_attributes_f pqpaaf
349: WHERE pqpaaf.assignment_id = n_assignment_id
350: AND pqpaaf.business_group_id = p_business_group_id
351: 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
352: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE

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

349: WHERE pqpaaf.assignment_id = n_assignment_id
350: AND pqpaaf.business_group_id = p_business_group_id
351: 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
352: AND ( v_assignment_eff_date between pqpaaf.EFFECTIVE_START_DATE and pqpaaf.EFFECTIVE_END_DATE
353: OR pqpaaf.EFFECTIVE_START_DATE = (select min(EFFECTIVE_START_DATE) from pqp_assignment_attributes_f where assignment_id = n_assignment_id
354: AND lgps_process_flag = nvl(l_mode,lgps_process_flag) AND business_group_id = p_business_group_id
355: AND EFFECTIVE_START_DATE BETWEEN v_assignment_eff_date AND v_eff_end_date));
356:
357: --This cursor will fetch the all elements for the assigment

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

388: WHERE pet.element_type_id = n_element_type_id
389: AND pet.INFORMATION_TYPE = 'PQP_UK_ELEMENT_ATTRIBUTION';
390:
391:
392: --This cursor to check the future date track records in pqp_assignment_attributes_f
393: CURSOR c_future_date(n_assignment_id NUMBER)
394: IS
395: SELECT max(EFFECTIVE_START_DATE)
396: FROM pqp_assignment_attributes_f pqpaaf

Line 396: FROM pqp_assignment_attributes_f pqpaaf

392: --This cursor to check the future date track records in pqp_assignment_attributes_f
393: CURSOR c_future_date(n_assignment_id NUMBER)
394: IS
395: SELECT max(EFFECTIVE_START_DATE)
396: FROM pqp_assignment_attributes_f pqpaaf
397: WHERE pqpaaf.assignment_id = n_assignment_id
398: AND pqpaaf.business_group_id = p_business_group_id;
399: --
400: --This cursor to correct the entries till the end date

Line 404: FROM pqp_assignment_attributes_f pqpaaf

400: --This cursor to correct the entries till the end date
401: CURSOR c_correct_pqp(n_assignment_id NUMBER)
402: IS
403: SELECT ASSIGNMENT_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, object_version_number
404: FROM pqp_assignment_attributes_f pqpaaf
405: WHERE pqpaaf.assignment_id = n_assignment_id
406: and pqpaaf.business_group_id = p_business_group_id
407: and pqpaaf.EFFECTIVE_START_DATE > v_max_date
408: -- and pqpaaf.EFFECTIVE_START_DATE between v_eff_start_date and v_eff_end_date_corr;

Line 424: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;

420: n_present number;
421: b_rate_type boolean;
422: b_element_present boolean;
423: b_input_value_present boolean;
424: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
425: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
426: l_lgps_pensionable_pay number;
427: b_pqp_assignment_found boolean;
428: b_pqp_found boolean;

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

421: b_rate_type boolean;
422: b_element_present boolean;
423: b_input_value_present boolean;
424: l_lgps_process_flag pqp_assignment_attributes_f.lgps_process_flag%type;
425: --l_lgps_pensionable_pay pqp_assignment_attributes_f.lgps_pensionable_pay%type;
426: l_lgps_pensionable_pay number;
427: b_pqp_assignment_found boolean;
428: b_pqp_found boolean;
429: c_pqp_assignment_row c_pqp_assignment%rowtype;

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

604: END IF;
605: END IF;
606:
607: IF b_pqp_assignment_found is NULL AND l_mode is not null THEN
608: --No records in PQP_ASSIGNMENT_ATTRIBUTES_F table matching mode - reprocess or incomplete.
609: raise skip_assignment;
610: END IF;
611:
612: OPEN c1_all_element(c_all_assignments.assignment_id);

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

752: END IF;
753: ----------
754: ELSE
755: IF l_mode is null then
756: l_warning_msg := 'Cannot process Assignment : '||c_all_assignments.assignment_number||' Future changes present in table pqp_assignment_attributes_f ';
757: fnd_file.put_line (fnd_file.LOG, l_warning_msg);
758: END IF;
759: raise skip_assignment;
760: END IF; --b_pqp_assignment_found

Line 982: FROM pqp_assignment_attributes_f pqaaf

978: v_trans_flag varchar2(30);
979: CURSOR C_Transtional_Flag
980: IS
981: SELECT LGPS_TRANS_ARRANG_FLAG
982: FROM pqp_assignment_attributes_f pqaaf
983: WHERE pqaaf.assignment_id = p_assignment_id
984: AND pqaaf.business_group_id = p_business_group_id
985: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
986: BEGIN

Line 998: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;

994: p_effective_date Date,
995: p_business_group_id NUMBER)
996: RETURN number
997: IS
998: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
999: CURSOR c_pension_pay
1000: IS
1001: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
1002: FROM pqp_assignment_attributes_f pqaaf

Line 1002: FROM pqp_assignment_attributes_f pqaaf

998: n_lgps_pension_pay pqp_assignment_attributes_f.LGPS_PENSIONABLE_PAY%type;
999: CURSOR c_pension_pay
1000: IS
1001: SELECT nvl(LGPS_PENSIONABLE_PAY,-1)
1002: FROM pqp_assignment_attributes_f pqaaf
1003: WHERE pqaaf.assignment_id = p_assignment_id
1004: AND pqaaf.business_group_id = p_business_group_id
1005: AND p_effective_date between pqaaf.effective_start_date and pqaaf.effective_end_date;
1006: BEGIN