APPS.PER_SALADMIN_UTILITY dependencies on HR_LOOKUPS

Line 677: from hr_lookups

673: is
674: l_pay_basis varchar2(100):=null;
675: cursor csr_lookup is
676: select description
677: from hr_lookups
678: where lookup_type = p_lookup_type
679: and lookup_code = p_lookup_code;
680: cursor csr_table is
681: select description

Line 684: ,hr_lookups

680: cursor csr_table is
681: select description
682: from pay_all_payrolls_f pap
683: ,per_all_assignments_f paa
684: ,hr_lookups
685: where pap.payroll_id = paa.payroll_id
686: and paa.assignment_id = p_assignment_id
687: and p_effective_date between paa.effective_start_date and paa.effective_end_date
688: and meaning = pap.period_type

Line 745: from hr_lookups

741: return varchar2
742: is
743: cursor csr_lookup is
744: select description
745: from hr_lookups
746: where lookup_type = p_lookup_type
747: and lookup_code = p_lookup_code;
748: v_description varchar2(100) := null;
749: begin

Line 1083: if hr_api.not_exists_in_hr_lookups

1079: ---if the pay proposal exists and has a different change date then
1080: ---create a new pay proposal
1081: if csr_pay_proposal%found and l_proposal_rec.change_date <> p_effective_date then
1082: --start of code change for bug 12591075
1083: if hr_api.not_exists_in_hr_lookups
1084: (p_effective_date => p_effective_date --Passing new proposal change date rather than prev proposal l_proposal_rec.change_date
1085: ,p_lookup_type => 'PROPOSAL_REASON'
1086: ,p_lookup_code => 'SALBASISCHG'
1087: ) then

Line 1439: -- check that the p_proposal_reason exists in hr_lookups.

1435:
1436: ----------------VKODEDAL 01-MAR-2007--------------------------------
1437: --FIX 5857948 -DEFAULT NEW PROPOSAL REASON TO SALARY BASIS CHANGE ADJUSTMENT
1438: --
1439: -- check that the p_proposal_reason exists in hr_lookups.
1440: --
1441: --Fix 6417656 - if SALBASISCHG doens't exist set the default reason to null
1442: if hr_api.not_exists_in_hr_lookups
1443: (p_effective_date => l_rec.change_date

Line 1442: if hr_api.not_exists_in_hr_lookups

1438: --
1439: -- check that the p_proposal_reason exists in hr_lookups.
1440: --
1441: --Fix 6417656 - if SALBASISCHG doens't exist set the default reason to null
1442: if hr_api.not_exists_in_hr_lookups
1443: (p_effective_date => l_rec.change_date
1444: ,p_lookup_type => 'PROPOSAL_REASON'
1445: ,p_lookup_code => 'SALBASISCHG'
1446: ) then