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_LOAD_OBJECTS dependencies on BEN_PL_F

Line 9: select pl_id from ben_pl_f

5: p_effective_date in date,
6: p_business_group_id in number)
7: return varchar2 is
8: Cursor csr_pl is
9: select pl_id from ben_pl_f
10: where short_code = p_short_code
11: and p_effective_date between effective_start_date and effective_end_date
12: and business_group_id = p_business_group_id;
13: l_pl_id ben_pl_f.pl_id%type ;

Line 13: l_pl_id ben_pl_f.pl_id%type ;

9: select pl_id from ben_pl_f
10: where short_code = p_short_code
11: and p_effective_date between effective_start_date and effective_end_date
12: and business_group_id = p_business_group_id;
13: l_pl_id ben_pl_f.pl_id%type ;
14:
15: begin
16: Open csr_pl;
17: Fetch csr_pl into l_pl_id;

Line 40: l_pl_id ben_pl_f.pl_id%type ;

36: ,p_owner in varchar2
37: ) is
38:
39: --
40: l_pl_id ben_pl_f.pl_id%type ;
41: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
42: l_ovn number ;
43: l_effective_start_date date ;
44: l_effective_end_date date ;

Line 50: l_created_by ben_pl_f.created_by%TYPE;

46: l_business_group_id hr_all_organization_units.business_group_id%type;
47: l_dt_mode varchar2(30);
48: --
49: --
50: l_created_by ben_pl_f.created_by%TYPE;
51: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
52: l_creation_date ben_pl_f.creation_date%TYPE;
53: l_last_update_date ben_pl_f.last_update_date%TYPE;
54: l_last_update_login ben_pl_f.last_update_login%TYPE;

Line 51: l_last_updated_by ben_pl_f.last_updated_by%TYPE;

47: l_dt_mode varchar2(30);
48: --
49: --
50: l_created_by ben_pl_f.created_by%TYPE;
51: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
52: l_creation_date ben_pl_f.creation_date%TYPE;
53: l_last_update_date ben_pl_f.last_update_date%TYPE;
54: l_last_update_login ben_pl_f.last_update_login%TYPE;
55: --

Line 52: l_creation_date ben_pl_f.creation_date%TYPE;

48: --
49: --
50: l_created_by ben_pl_f.created_by%TYPE;
51: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
52: l_creation_date ben_pl_f.creation_date%TYPE;
53: l_last_update_date ben_pl_f.last_update_date%TYPE;
54: l_last_update_login ben_pl_f.last_update_login%TYPE;
55: --
56: -- Create a plan corresponding to Rate matrix.

Line 53: l_last_update_date ben_pl_f.last_update_date%TYPE;

49: --
50: l_created_by ben_pl_f.created_by%TYPE;
51: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
52: l_creation_date ben_pl_f.creation_date%TYPE;
53: l_last_update_date ben_pl_f.last_update_date%TYPE;
54: l_last_update_login ben_pl_f.last_update_login%TYPE;
55: --
56: -- Create a plan corresponding to Rate matrix.
57: --

Line 54: l_last_update_login ben_pl_f.last_update_login%TYPE;

50: l_created_by ben_pl_f.created_by%TYPE;
51: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
52: l_creation_date ben_pl_f.creation_date%TYPE;
53: l_last_update_date ben_pl_f.last_update_date%TYPE;
54: l_last_update_login ben_pl_f.last_update_login%TYPE;
55: --
56: -- Create a plan corresponding to Rate matrix.
57: --
58: Cursor csr_pl is

Line 59: select pl_id,object_version_number from ben_pl_f

55: --
56: -- Create a plan corresponding to Rate matrix.
57: --
58: Cursor csr_pl is
59: select pl_id,object_version_number from ben_pl_f
60: where short_code = p_pl_short_code
61: and l_effective_date between effective_start_date and effective_end_date
62: and business_group_id = l_business_group_id;
63: --

Line 145: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode('BEN_PL_F','PL_ID', l_pl_id, l_effective_date) ;

141: ,P_EFFECTIVE_END_DATE => l_effective_end_date
142: ,P_OBJECT_VERSION_NUMBER => l_ovn
143: );
144: Else
145: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode('BEN_PL_F','PL_ID', l_pl_id, l_effective_date) ;
146:
147:
148: BEN_PLAN_API.UPDATE_PLAN(
149: P_EFFECTIVE_DATE => l_effective_date

Line 181: l_pl_id ben_pl_f.pl_id%type ;

177: ,p_effective_date in varchar2
178: ,p_owner in varchar2
179: ) is
180: --
181: l_pl_id ben_pl_f.pl_id%type ;
182: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type;
183: l_business_group_id hr_all_organization_units.business_group_id%type;
184: --
185: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;

Line 210: select pl_id from ben_pl_f

206: --
207: -- plan corresponding to Rate matrix.
208: --
209: /* Cursor csr_pl is
210: select pl_id from ben_pl_f
211: where short_code = p_pl_short_code
212: and l_effective_date between effective_start_date and effective_end_date
213: and business_group_id = l_business_group_id;
214: */

Line 528: l_pl_id ben_pl_f.pl_id%type;

524: l_crd_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;
530: l_abr ben_acty_base_rt_f.acty_base_rt_id%type;
531: l_ovn number := 1;
532: l_effective_start_date date ;

Line 529: l_pl_name ben_pl_f.short_code%type;

525: l_crd_name pqh_criteria_rate_defn.short_name%type;
526: l_rate_matrix_node_id pqh_rate_matrix_rates_f.rate_matrix_node_id%type;
527: l_rt_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
528: l_pl_id ben_pl_f.pl_id%type;
529: l_pl_name ben_pl_f.short_code%type;
530: l_abr ben_acty_base_rt_f.acty_base_rt_id%type;
531: l_ovn number := 1;
532: l_effective_start_date date ;
533: l_effective_end_date date ;

Line 539: l_created_by ben_pl_f.created_by%TYPE;

535: l_business_group_id hr_all_organization_units.business_group_id%type;
536: l_dt_mode varchar2(30);
537: --
538: --
539: l_created_by ben_pl_f.created_by%TYPE;
540: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
541: l_creation_date ben_pl_f.creation_date%TYPE;
542: l_last_update_date ben_pl_f.last_update_date%TYPE;
543: l_last_update_login ben_pl_f.last_update_login%TYPE;

Line 540: l_last_updated_by ben_pl_f.last_updated_by%TYPE;

536: l_dt_mode varchar2(30);
537: --
538: --
539: l_created_by ben_pl_f.created_by%TYPE;
540: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
541: l_creation_date ben_pl_f.creation_date%TYPE;
542: l_last_update_date ben_pl_f.last_update_date%TYPE;
543: l_last_update_login ben_pl_f.last_update_login%TYPE;
544: --

Line 541: l_creation_date ben_pl_f.creation_date%TYPE;

537: --
538: --
539: l_created_by ben_pl_f.created_by%TYPE;
540: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
541: l_creation_date ben_pl_f.creation_date%TYPE;
542: l_last_update_date ben_pl_f.last_update_date%TYPE;
543: l_last_update_login ben_pl_f.last_update_login%TYPE;
544: --
545: -- Create a abr corresponding to Criteria rate defn in Rate matrix.

Line 542: l_last_update_date ben_pl_f.last_update_date%TYPE;

538: --
539: l_created_by ben_pl_f.created_by%TYPE;
540: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
541: l_creation_date ben_pl_f.creation_date%TYPE;
542: l_last_update_date ben_pl_f.last_update_date%TYPE;
543: l_last_update_login ben_pl_f.last_update_login%TYPE;
544: --
545: -- Create a abr corresponding to Criteria rate defn in Rate matrix.
546: --

Line 543: l_last_update_login ben_pl_f.last_update_login%TYPE;

539: l_created_by ben_pl_f.created_by%TYPE;
540: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
541: l_creation_date ben_pl_f.creation_date%TYPE;
542: l_last_update_date ben_pl_f.last_update_date%TYPE;
543: l_last_update_login ben_pl_f.last_update_login%TYPE;
544: --
545: -- Create a abr corresponding to Criteria rate defn in Rate matrix.
546: --
547: Cursor csr_plan is

Line 554: From ben_pl_f

550: and business_group_id = l_business_group_id;
551: --
552: Cursor csr_plan_name is
553: select short_code
554: From ben_pl_f
555: Where pl_id = l_pl_id
556: and l_effective_date between effective_start_date and effective_end_date
557: and business_group_id = l_business_group_id;
558:

Line 1081: select pl_id from ben_pl_f

1077: Select pqh_criteria_rate_factors_s.nextval
1078: From dual;
1079:
1080: /* Cursor csr_prm is
1081: select pl_id from ben_pl_f
1082: where short_code = p_parent_rate_matrix_code
1083: and l_effective_date between effective_start_date and effective_end_date
1084: and business_group_id = l_business_group_id;
1085: */