DBA Data[Home] [Help]

APPS.PYCADAR_PKG dependencies on HR_LOOKUPS

Line 1171: from hr_lookups

1167: p_lookup_code in VARCHAR2)
1168: return VARCHAR2 is
1169: cursor csr_label_meaning is
1170: select meaning
1171: from hr_lookups
1172: where lookup_type = p_lookup_type
1173: and lookup_code = p_lookup_code;
1174:
1175: l_label_meaning varchar2(80);

Line 1272: ,hr_lookups hrl

1268: distinct paa.assignment_id
1269: ,pai.action_context_id
1270: FROM pay_assignment_actions paa
1271: ,pay_payroll_actions ppa
1272: ,hr_lookups hrl
1273: ,pay_action_information pai
1274: ,per_time_periods ptp
1275: WHERE /* paa.assignment_id = c_assignment_id */
1276: ppa.effective_Date BETWEEN c_start_date

Line 1317: ,hr_lookups hrl

1313: distinct paa.assignment_id
1314: ,pai.action_context_id
1315: FROM pay_assignment_actions paa
1316: ,pay_payroll_actions ppa
1317: ,hr_lookups hrl
1318: ,hr_assignment_set_amendments hasa
1319: ,pay_action_information pai
1320: ,per_time_periods ptp
1321: WHERE ppa.effective_Date BETWEEN c_start_date