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.PER_ALT_LOOKUPS_PKG dependencies on PER_BUSINESS_GROUPS

Line 15: l_legislation_code per_business_groups.legislation_code%type;

11: P_REQUIRED_DEFAULTS in varchar2,
12: P_DEFAULT_VALUE in varchar2,
13: P_LEGISLATION_CODE in varchar2 default null) IS
14: --
15: l_legislation_code per_business_groups.legislation_code%type;
16: --
17: cursor csr_table_name is
18: select a.user_table_id
19: from pay_user_tables_v a

Line 91: from per_business_groups

87: hr_utility.set_location(l_procedure , 5);
88: --
89: if P_BUSINESS_GROUP_ID is not null then
90: select legislation_code into l_legislation_code
91: from per_business_groups
92: where business_group_id = P_BUSINESS_GROUP_ID;
93: --
94: else
95: --

Line 284: (cn_business_group_id IN per_business_groups.business_group_id%TYPE,

280: ---------------------------------------------------------------------------
281: -- |---------------- Clean_pay_tables -------------------------------| -
282: ---------------------------------------------------------------------------
283: procedure clean_pay_tables
284: (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
285: cp_user_table_name IN pay_user_tables.user_table_name%TYPE) IS
286:
287:
288: ln_row_count number := 1;

Line 386: Procedure Set_instance_value (cn_business_group_id IN per_business_groups.business_group_id%TYPE,

382:
383: ------------------------------------------------------------------
384: -- ----- set_instance_value ------------------------------------|
385: ------------------------------------------------------------------
386: Procedure Set_instance_value (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
387: cp_legislation_code IN per_business_groups.legislation_code%TYPE,
388: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
389: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
390: cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,

Line 387: cp_legislation_code IN per_business_groups.legislation_code%TYPE,

383: ------------------------------------------------------------------
384: -- ----- set_instance_value ------------------------------------|
385: ------------------------------------------------------------------
386: Procedure Set_instance_value (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
387: cp_legislation_code IN per_business_groups.legislation_code%TYPE,
388: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
389: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
390: cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,
391: cp_value IN pay_user_column_instances_f.value%TYPE

Line 533: (cn_business_group_id IN per_business_groups.business_group_id%TYPE,

529: -- Only process the Business_group if provided
530: -- or Process all the business_groups for a given legislation_code
531:
532: Procedure Update_Instance_value
533: (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
534: cp_legislation_code IN per_business_groups.legislation_code%TYPE,
535: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
536: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
537: cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,

Line 534: cp_legislation_code IN per_business_groups.legislation_code%TYPE,

530: -- or Process all the business_groups for a given legislation_code
531:
532: Procedure Update_Instance_value
533: (cn_business_group_id IN per_business_groups.business_group_id%TYPE,
534: cp_legislation_code IN per_business_groups.legislation_code%TYPE,
535: cp_user_table_name IN pay_user_tables.user_table_name%TYPE ,
536: cp_user_column_name IN pay_user_columns.user_column_name%TYPE ,
537: cp_row_name IN pay_user_rows_f.row_low_range_or_name%TYPE ,
538: cp_value IN pay_user_column_instances_f.value%TYPE

Line 550: CURSOR Get_Business_group_id (cp_legislation_code per_business_groups.legislation_code%TYPE) IS

546:
547: --
548: -- Local Cursor Definition
549:
550: CURSOR Get_Business_group_id (cp_legislation_code per_business_groups.legislation_code%TYPE) IS
551: SELECT BUSINESS_GROUP_ID
552: FROM PER_BUSINESS_GROUPS
553: WHERE LEGISLATION_CODE = cp_legislation_code;
554:

Line 552: FROM PER_BUSINESS_GROUPS

548: -- Local Cursor Definition
549:
550: CURSOR Get_Business_group_id (cp_legislation_code per_business_groups.legislation_code%TYPE) IS
551: SELECT BUSINESS_GROUP_ID
552: FROM PER_BUSINESS_GROUPS
553: WHERE LEGISLATION_CODE = cp_legislation_code;
554:
555:
556:

Line 569: from per_business_groups pbg

565: ln_temp_leg_code := '';
566:
567: Begin
568: select rtrim(ltrim(pbg.legislation_code)) into ln_temp_leg_code
569: from per_business_groups pbg
570: where pbg.business_group_id = cn_business_group_id;
571: end;
572:
573: if (ln_temp_leg_code = '') then