[Home] [Help]
1924: ,p_amount IN NUMBER
1925: ,p_med_levy IN NUMBER) IS
1926: SELECT /*+ INDEX(PURF) ORDERED */ NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
1927: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
1928: FROM pay_user_tables put,
1929: pay_user_rows_F purf,
1930: pay_user_columns puc,
1931: pay_user_column_instances_f pucif
1932: where put.legislation_code='AU'
2081:
2082:
2083: CURSOR csr_get_prev_age IS
2084: SELECT /*+ index(PURF) ORDERED */ to_number(pucif.value) -- bug8647962
2085: FROM pay_user_tables put,
2086: pay_user_rows_F purf,
2087: pay_user_columns puc,
2088: pay_user_column_instances_f pucif
2089: where put.legislation_code='AU'
2563: ,p_amount IN NUMBER
2564: ,p_med_levy IN NUMBER) IS
2565: SELECT /*+ INDEX(PURF) ORDERED */ NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
2566: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
2567: FROM pay_user_tables put,
2568: pay_user_rows_F purf,
2569: pay_user_columns puc,
2570: pay_user_column_instances_f pucif
2571: where put.legislation_code='AU'
3692: ,p_amount IN NUMBER
3693: ,p_med_levy IN NUMBER) IS
3694: SELECT /*+ INDEX(PURF) ORDERED */ NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
3695: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
3696: FROM pay_user_tables put,
3697: pay_user_rows_F purf,
3698: pay_user_columns puc,
3699: pay_user_column_instances_f pucif
3700: where put.legislation_code='AU'
3747: AND pbt.balance_type_id = pdb.balance_type_id
3748: AND pbd.balance_dimension_id = pdb.balance_dimension_id
3749: AND pbd.dimension_name = '_ASG_LE_YTD';
3750:
3751: cursor c_get_etp_cap_detail (c_user_table_name pay_user_tables.user_table_name%type) is
3752: select
3753: pr.row_low_range_or_name low_range,
3754: pr.row_high_range high_range,
3755: pci.value
3752: select
3753: pr.row_low_range_or_name low_range,
3754: pr.row_high_range high_range,
3755: pci.value
3756: from pay_user_tables pt, PAY_USER_COLUMNS pc, PAY_USER_ROWS_F pr, PAY_USER_COLUMN_INSTANCES_F pci
3757: where pt.user_table_name = c_user_table_name
3758: and pt.user_table_id = pc.user_table_id
3759: and pt.user_table_id = pr.user_table_id
3760: and pr.user_row_id = pci.user_row_id