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.PQH_RBC_RATE_RETRIEVAL dependencies on BEN_ELIGY_CRITERIA

Line 18: short_code ben_eligy_criteria.short_code%type,

14: g_empty_tab ff_exec.outputs_t; -- donot populate. Only to be used a default value
15: --
16: --
17: Type tc_criteria is record(
18: short_code ben_eligy_criteria.short_code%type,
19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,
20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,

Line 19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,

15: --
16: --
17: Type tc_criteria is record(
18: short_code ben_eligy_criteria.short_code%type,
19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,
20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,
23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,

Line 20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,

16: --
17: Type tc_criteria is record(
18: short_code ben_eligy_criteria.short_code%type,
19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,
20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,
23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,
24: time_entry_access_col_name2 ben_eligy_criteria.time_entry_access_col_name2%type);

Line 21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,

17: Type tc_criteria is record(
18: short_code ben_eligy_criteria.short_code%type,
19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,
20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,
23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,
24: time_entry_access_col_name2 ben_eligy_criteria.time_entry_access_col_name2%type);
25: --

Line 22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,

18: short_code ben_eligy_criteria.short_code%type,
19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,
20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,
23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,
24: time_entry_access_col_name2 ben_eligy_criteria.time_entry_access_col_name2%type);
25: --
26: Type tc_criteria_tbl is table of tc_criteria index by binary_integer;

Line 23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,

19: crit_col1_datatype ben_eligy_criteria.crit_col1_datatype%type,
20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,
23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,
24: time_entry_access_col_name2 ben_eligy_criteria.time_entry_access_col_name2%type);
25: --
26: Type tc_criteria_tbl is table of tc_criteria index by binary_integer;
27: --

Line 24: time_entry_access_col_name2 ben_eligy_criteria.time_entry_access_col_name2%type);

20: time_entry_access_table_name1 ben_eligy_criteria.time_entry_access_table_name1%type,
21: time_entry_access_col_name1 ben_eligy_criteria.time_entry_access_col_name1%type,
22: crit_col2_datatype ben_eligy_criteria.crit_col2_datatype%type,
23: time_entry_access_table_name2 ben_eligy_criteria.time_entry_access_table_name2%type,
24: time_entry_access_col_name2 ben_eligy_criteria.time_entry_access_col_name2%type);
25: --
26: Type tc_criteria_tbl is table of tc_criteria index by binary_integer;
27: --
28: --

Line 1150: from ben_eligy_criteria

1146: -- Cursor to select only those eligibility criteria where time card override is not null.
1147: --
1148: Cursor csr_timecard_ovrrd_exists is
1149: Select *
1150: from ben_eligy_criteria
1151: Where (time_entry_access_table_name1 is not null or time_entry_access_table_name2 is not null)
1152: and business_group_id = p_business_group_id;
1153: --
1154: l_proc varchar2(72) := g_package||'populate_person_override_val';