APPS.PER_SALADMIN_UTILITY dependencies on HR_LOOKUPS

Line 646: from hr_lookups

642: is
643: l_pay_basis varchar2(100):=null;
644: cursor csr_lookup is
645: select description
646: from hr_lookups
647: where lookup_type = p_lookup_type
648: and lookup_code = p_lookup_code;
649: cursor csr_table is
650: select description

Line 653: ,hr_lookups

649: cursor csr_table is
650: select description
651: from pay_all_payrolls_f pap
652: ,per_all_assignments_f paa
653: ,hr_lookups
654: where pap.payroll_id = paa.payroll_id
655: and paa.assignment_id = p_assignment_id
656: and p_effective_date between paa.effective_start_date and paa.effective_end_date
657: and meaning = pap.period_type

Line 714: from hr_lookups

710: return varchar2
711: is
712: cursor csr_lookup is
713: select description
714: from hr_lookups
715: where lookup_type = p_lookup_type
716: and lookup_code = p_lookup_code;
717: v_description varchar2(100) := null;
718: begin

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

1210:
1211: ----------------VKODEDAL 01-MAR-2007--------------------------------
1212: --FIX 5857948 -DEFAULT NEW PROPOSAL REASON TO SALARY BASIS CHANGE ADJUSTMENT
1213: --
1214: -- check that the p_proposal_reason exists in hr_lookups.
1215: --
1216: --Fix 6417656 - if SALBASISCHG doens't exist set the default reason to null
1217: if hr_api.not_exists_in_hr_lookups
1218: (p_effective_date => l_rec.change_date

Line 1217: if hr_api.not_exists_in_hr_lookups

1213: --
1214: -- check that the p_proposal_reason exists in hr_lookups.
1215: --
1216: --Fix 6417656 - if SALBASISCHG doens't exist set the default reason to null
1217: if hr_api.not_exists_in_hr_lookups
1218: (p_effective_date => l_rec.change_date
1219: ,p_lookup_type => 'PROPOSAL_REASON'
1220: ,p_lookup_code => 'SALBASISCHG'
1221: ) then