DBA Data[Home] [Help]

APPS.PER_JP_CMA_UTILITY_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 8: c_car_element_name constant pay_element_types_f.element_name%type := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';

4: -- Constants
5: --
6: c_package constant varchar2(31) := 'per_jp_cma_utility_pkg.';
7: --
8: c_car_element_name constant pay_element_types_f.element_name%type := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
9: c_train_element_name constant pay_element_types_f.element_name%type := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
10: --
11: c_non_taxable_udt_name constant varchar2(80) := 'T_SAL_CMA_PRIVATE_TRANSPORT_NTXBL_ERN_MAX';
12: c_non_taxable_udt_col_name constant varchar2(80) := 'MAX';

Line 9: c_train_element_name constant pay_element_types_f.element_name%type := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';

5: --
6: c_package constant varchar2(31) := 'per_jp_cma_utility_pkg.';
7: --
8: c_car_element_name constant pay_element_types_f.element_name%type := 'SAL_CMA_PRIVATE_TRANSPORT_INFO';
9: c_train_element_name constant pay_element_types_f.element_name%type := 'SAL_CMA_PUBLIC_TRANSPORT_INFO';
10: --
11: c_non_taxable_udt_name constant varchar2(80) := 'T_SAL_CMA_PRIVATE_TRANSPORT_NTXBL_ERN_MAX';
12: c_non_taxable_udt_col_name constant varchar2(80) := 'MAX';
13: c_equivalent_cost_udt_col_name constant varchar2(80) := 'FARE_EQUIVALENT_AMT_PRIORITY_FLAG';

Line 251: from pay_element_types_f pet,

247: fnd_number.canonical_to_number(min(decode(piv.display_sequence, 7, peev.screen_entry_value, NULL))) parking_fees,
248: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 8, peev.screen_entry_value, NULL))), 0) equivalent_cost,
249: substrb(min(decode(piv.display_sequence, 9, peev.screen_entry_value, NULL)), 1, 6) pay_start,
250: substrb(min(decode(piv.display_sequence, 10, peev.screen_entry_value, NULL)), 1, 6) pay_end
251: from pay_element_types_f pet,
252: pay_element_links_f pel,
253: pay_element_entries_f pee,
254: pay_element_entry_values_f peev,
255: pay_input_values_f piv

Line 335: from pay_element_types_f pet,

331: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence,7, peev.screen_entry_value, NULL))), 0) amount,
332: substrb(min(decode(piv.display_sequence, 8, peev.screen_entry_value, NULL)), 1, 6) pay_start,
333: substrb(min(decode(piv.display_sequence, 9, peev.screen_entry_value, NULL)), 1, 6) pay_end,
334: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 10, peev.screen_entry_value, NULL))), 0) si_month
335: from pay_element_types_f pet,
336: pay_element_links_f pel,
337: pay_element_entries_f pee,
338: pay_element_entry_values_f peev,
339: pay_input_values_f piv