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_OSP_TEMPLATE dependencies on DUAL

Line 422: --FROM DUAL

418: -- ,p_base_name||'OSP Scheme Member'
419: -- ,p_business_group_id
420: -- ,p_base_name||'OSP Scheme Members Group'
421: -- ,1
422: --FROM DUAL
423: --WHERE NOT EXISTS
424: -- (SELECT 1
425: -- FROM ben_benfts_grp
426: -- WHERE business_group_id = p_business_group_id

Line 528: FROM DUAL

524: ,2
525: ,2
526: ,2
527: ,hr_api.g_sot
528: FROM DUAL
529: WHERE NOT EXISTS
530: ( SELECT 1 FROM pqp_configuration_modules
531: WHERE module_name = 'Absence Schemes'
532: and legislation_code = 'GB'

Line 582: FROM DUAL

578: ,2
579: ,2
580: ,hr_api.g_sot
581: ,NULL
582: FROM DUAL
583: WHERE NOT EXISTS
584: ( SELECT 1 FROM pqp_configuration_types
585: WHERE configuration_type = 'PQP_GB_OSP_OMP_CONFIG'
586: AND module_id = l_module_id

Line 640: ,p_dual_rolling_duration in number default null

636: ,p_enable_ent_proration in varchar2 default null -- LG
637: ,p_scheme_type in varchar2 default null -- LG
638: ,p_abs_schedule_wp in varchar2 default null -- LG
639: -- Added additional segments for CSS
640: ,p_dual_rolling_duration in number default null
641: ,p_dual_rolling_UOM in varchar2 default null
642: ,p_ft_round_config in varchar2 default null
643: ,p_pt_round_config in varchar2 default null
644:

Line 641: ,p_dual_rolling_UOM in varchar2 default null

637: ,p_scheme_type in varchar2 default null -- LG
638: ,p_abs_schedule_wp in varchar2 default null -- LG
639: -- Added additional segments for CSS
640: ,p_dual_rolling_duration in number default null
641: ,p_dual_rolling_UOM in varchar2 default null
642: ,p_ft_round_config in varchar2 default null
643: ,p_pt_round_config in varchar2 default null
644:
645: )

Line 697: p_dual_rolling_duration (N)

693: p_enable_ent_proration (V) LG
694: p_scheme_type (V) default null -- LG
695: p_abs_schedule_wp (V) default null -- LG
696: -- Added additional segments for CSS
697: p_dual_rolling_duration (N)
698: p_dual_rolling_UOM (N)
699: p_ft_round_config (V)
700: p_pt_round_config (V)
701: ----------------------------------------------------------------------*/

Line 698: p_dual_rolling_UOM (N)

694: p_scheme_type (V) default null -- LG
695: p_abs_schedule_wp (V) default null -- LG
696: -- Added additional segments for CSS
697: p_dual_rolling_duration (N)
698: p_dual_rolling_UOM (N)
699: p_ft_round_config (V)
700: p_pt_round_config (V)
701: ----------------------------------------------------------------------*/
702: --

Line 839: TYPE := p_dual_rolling_duration ; --'4';

835: TYPE := 'PQP_GB_OSP_CALENDAR_RULES';
836:
837:
838: l_eei_information20 pay_element_type_extra_info.eei_information29%
839: TYPE := p_dual_rolling_duration ; --'4';
840:
841:
842: l_eei_information21 pay_element_type_extra_info.eei_information29%
843: TYPE := p_dual_rolling_UOM ; --'YEARS';

Line 843: TYPE := p_dual_rolling_UOM ; --'YEARS';

839: TYPE := p_dual_rolling_duration ; --'4';
840:
841:
842: l_eei_information21 pay_element_type_extra_info.eei_information29%
843: TYPE := p_dual_rolling_UOM ; --'YEARS';
844:
845:
846: l_eei_information22 pay_element_type_extra_info.eei_information22%
847: TYPE := p_enable_ent_proration ; -- LG

Line 1386: FROM dual;

1382:
1383: CURSOR csr_get_next_udt_row_seq
1384: IS
1385: SELECT pay_user_rows_s.NEXTVAL
1386: FROM dual;
1387:
1388: l_proc_name VARCHAR2(72) := g_package_name || 'create_udt';
1389: l_user_table_id pay_user_tables.user_table_id%TYPE;
1390: l_user_column_id pay_user_columns.user_column_id%TYPE;

Line 1958: IF p_sch_cal_type = 'DUALROLLING' THEN

1954: --
1955: -- create user structure from the template
1956: --
1957:
1958: IF p_sch_cal_type = 'DUALROLLING' THEN
1959: l_configuration_information2 := 'CIVILSERVICE_OSP';
1960: ELSE
1961: l_configuration_information2 := 'REGULAR_OSP';
1962: END IF;

Line 2089: IF p_sch_cal_type <> 'DUALROLLING' -- In Dual Rolling Schemes we do not support band3 and 4

2085: END IF; -- End if of bnd2 sub name not null check ...
2086: l_ele_pp(l_ctr) := l_pay_ele_correction_pp;
2087:
2088:
2089: IF p_sch_cal_type <> 'DUALROLLING' -- In Dual Rolling Schemes we do not support band3 and 4
2090: THEN
2091:
2092: l_ctr := l_ctr + 1; --7
2093:

Line 2133: END IF; -- IF p_sch_cal_type <> 'DUALROLLING'

2129: END IF; -- End if of bnd4 sub name not null check...
2130: l_ele_pp(l_ctr) := l_pay_ele_correction_pp;
2131:
2132:
2133: END IF; -- IF p_sch_cal_type <> 'DUALROLLING'
2134:
2135: l_ctr := l_ctr + 1; --11 or 7
2136:
2137: IF l_days_hours IS NULL

Line 2217: IF p_bnd3_ele_sub_name IS NOT NULL AND p_sch_cal_type <> 'DUALROLLING' THEN

2213: l_ctr := l_ctr + 1;
2214: l_bal_name(l_ctr) := p_abs_ele_name||' Band2 Hours Pay Entitlement';
2215: l_bal_new_name(l_ctr) := p_abs_ele_name||' '||p_bnd2_ele_sub_name||' Band2 Hours Pay Entitlement';
2216:
2217: IF p_bnd3_ele_sub_name IS NOT NULL AND p_sch_cal_type <> 'DUALROLLING' THEN
2218:
2219:
2220: l_ctr := l_ctr + 1;
2221: l_bal_name(l_ctr) := p_abs_ele_name||' Band3 Pay Paid';

Line 2380: IF p_sch_cal_type <> 'DUALROLLING'

2376: l_retro_ele_name(l_ctr) := l_ele_new_name(l_idx);
2377: l_retro_eei_info19(l_ctr) := 'Band2 Correction Info';
2378:
2379:
2380: IF p_sch_cal_type <> 'DUALROLLING'
2381: THEN
2382:
2383: --5
2384: l_ctr := l_ctr + 1;

Line 2405: END IF; -- IF p_sch_cal_type <> 'DUALROLLING'

2401: l_idx := l_ele_new_name.NEXT(l_idx);
2402: l_retro_ele_name(l_ctr) := l_ele_new_name(l_idx);
2403: l_retro_eei_info19(l_ctr) := 'Band4 Correction Info';
2404:
2405: END IF; -- IF p_sch_cal_type <> 'DUALROLLING'
2406:
2407: -- Added the IF check, as this is created only for DAYS
2408: IF l_days_hours IS NULL
2409: THEN

Line 2437: -- 5 because I'm testing only for dual rolling so 3 and 4 won't exist

2433:
2434: END LOOP; -- l_idx := l_main_ele_name.FIRST;
2435:
2436:
2437: -- 5 because I'm testing only for dual rolling so 3 and 4 won't exist
2438: -- l_ctr := l_ctr + 1;
2439: -- temporarily after loop as min pay does't have a retro twin yet
2440: -- l_main_ele_name(l_ctr) := l_ele_new_name(l_ele_new_name.LAST); --it is the last to be added
2441: -- l_main_eei_info19(l_ctr) := 'Minimum Pay Info';

Line 2548: IF p_sch_cal_type = 'DUALROLLING' THEN

2544: ,p_legislation_code => 'GB'
2545: ,p_udt_rows => l_udt_rows
2546: );
2547:
2548: IF p_sch_cal_type = 'DUALROLLING' THEN
2549: -- insert a LOS range of 0 to 999999
2550: l_idx := l_udt_rows.LAST;
2551: l_udt_rows(l_idx+1).row_low_range_or_name := '0';
2552: l_udt_rows(l_idx+1).row_high_range := '999999';

Line 2556: END IF; -- IF p_sch_cal_type = 'DUALROLLING' THEN

2552: l_udt_rows(l_idx+1).row_high_range := '999999';
2553: l_udt_rows(l_idx+1).business_group_id := p_bg_id;
2554: l_udt_rows(l_idx+1).legislation_code := NULL;
2555: l_udt_rows(l_idx+1).display_sequence := l_udt_rows(l_idx).display_sequence+1;
2556: END IF; -- IF p_sch_cal_type = 'DUALROLLING' THEN
2557:
2558: IF p_scheme_type = 'LOCALGOVT' THEN
2559: -- insert a LOS range of 0 to 999999
2560: l_idx := l_udt_rows.LAST;

Line 2629: IF p_sch_cal_type = 'DUALROLLING' THEN

2625: )
2626: );
2627:
2628:
2629: IF p_sch_cal_type = 'DUALROLLING' THEN
2630:
2631: --Insert four column instances
2632: --Two for row -99999 -99999 and columns Band1 and Band2 values 100 and 50 respectively
2633: --Two for row 0 99999 and columsn Band1 and Band2 values 182 and 183 respectively

Line 2781: END IF; --IF p_sch_cal_type = 'DUALROLLING' THEN create the entitlement values also

2777: AND SYSDATE BETWEEN urws.effective_start_date
2778: AND urws.effective_end_date;
2779:
2780:
2781: END IF; --IF p_sch_cal_type = 'DUALROLLING' THEN create the entitlement values also
2782:
2783:
2784: IF p_scheme_type = 'LOCALGOVT' THEN
2785: