DBA Data[Home] [Help]

APPS.PY_ZA_TAX_REG dependencies on FND_LOOKUP_VALUES

Line 56: to reference fnd_lookup_values

52: Secure views were used for Performance enhancement.
53: A. Mahanty 14/04/2005 115.21 3491357 BRA Enh. Balance Value retrieval
54: modified.
55: J.N. Louw 23/06/2004 115.20 3694450 Modified assignment_nature
56: to reference fnd_lookup_values
57: instead of hr_lookups
58: R. Pahune 09/02/2004 115.19 3400581 Modified the cursor
59: csr_processed_assignments.
60: N. Venugopal 09/01/2004 115.18 3221746 removed set serverout on for gscc compliance.

Line 726: , fnd_lookup_values fcl

722: nvl(fcl.meaning, 'A') nature
723: FROM
724: per_all_assignments_f ass
725: , per_assignment_extra_info aei
726: , fnd_lookup_values fcl
727: WHERE ass.assignment_id = c_assignment_id
728: AND ass.effective_start_date =
729: (
730: SELECT max(paf2.effective_start_date)

Line 1928: , fnd_lookup_values fcl

1924: aei.aei_information15 foreign_income
1925: FROM
1926: per_all_assignments_f ass
1927: , per_assignment_extra_info aei
1928: , fnd_lookup_values fcl
1929: WHERE ass.assignment_id = c_assignment_id
1930: AND ass.effective_start_date =
1931: (
1932: SELECT max(paf2.effective_start_date)