DBA Data[Home] [Help]

APPS.HR_SALARY_BASIS_API dependencies on PER_PAY_BASES

Line 74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

70: ) is
71: --
72: -- Declare cursors and local variables
73: --
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;

Line 75: l_business_group_id per_pay_bases.business_group_id%TYPE;

71: --
72: -- Declare cursors and local variables
73: --
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;

Line 76: l_name per_pay_bases.name%TYPE;

72: -- Declare cursors and local variables
73: --
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;

Line 78: l_object_version_number per_pay_bases.object_version_number%TYPE;

74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;

Line 79: l_input_value_id per_pay_bases.input_value_id%TYPE;

75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

Line 80: l_rate_id per_pay_bases.rate_id%TYPE;

76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;

Line 81: l_pay_basis per_pay_bases.pay_basis%TYPE;

77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --

Line 82: l_rate_basis per_pay_bases.rate_basis%TYPE;

78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
86: begin

Line 83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
86: begin
87: --

Line 84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;

80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 424: l_object_version_number per_pay_bases.object_version_number%TYPE;

420: --
421: -- Declare cursors and local variables
422: --
423: --
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;

Line 426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

422: --
423: --
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;

Line 427: l_business_group_id per_pay_bases.business_group_id%TYPE;

423: --
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;

Line 428: l_name per_pay_bases.name%TYPE;

424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;

Line 430: l_input_value_id per_pay_bases.input_value_id%TYPE;

426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

Line 431: l_rate_id per_pay_bases.rate_id%TYPE;

427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;

Line 432: l_pay_basis per_pay_bases.pay_basis%TYPE;

428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --

Line 433: l_rate_basis per_pay_bases.rate_basis%TYPE;

429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
437: --

Line 434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;

430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
437: --
438: -- Declare cursors

Line 435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;

431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
437: --
438: -- Declare cursors
439: --

Line 552: from per_pay_bases

548:
549: --
550: select business_group_id
551: into l_business_group_id
552: from per_pay_bases
553: where pay_basis_id = p_pay_basis_id;
554:
555: per_ppb_upd.upd
556: (p_pay_basis_id => p_pay_basis_id