APPS.PQP_INI_BAL dependencies on FND_NUMBER

Line 1253: select /*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) *

1249:
1250: cursor c_get_balance_val(cp_balance_type_id NUMBER
1251: ,cp_assignment_action_id NUMBER)
1252: is
1253: select /*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) *
1254: FEED.scale),0) tot
1255: from
1256: pay_balance_feeds_f FEED
1257: ,pay_run_result_values TARGET

Line 1337: to_date('06-04-' || to_char( fnd_number.canonical_to_number(

1333: /* fin year start is last two years for a even tax year and last one
1334: * year for a odd tax year
1335:
1336: */
1337: to_date('06-04-' || to_char( fnd_number.canonical_to_number(
1338: to_char( BPTP.regular_payment_date,'YYYY'))
1339: + decode(sign(BPTP.regular_payment_date - to_date('06-04-'
1340: || to_char(BPTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
1341: -1,-1,0) -

Line 1343: fnd_number.canonical_to_number(

1339: + decode(sign(BPTP.regular_payment_date - to_date('06-04-'
1340: || to_char(BPTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
1341: -1,-1,0) -
1342: mod(
1343: fnd_number.canonical_to_number(
1344: to_char( BPTP.regular_payment_date,'YYYY'))
1345: + decode(sign( BPTP.regular_payment_date - to_date('06-04-'
1346: || to_char(BPTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
1347: -1,0,-1),2)

Line 1416: SELECT nvl((fnd_number.canonical_to_number(TARGET.result_value)

1412: ,cp_assignment_action_id NUMBER
1413: ,cp_element_entry_id NUMBER
1414: ,cp_payroll_action_id NUMBER)
1415: is
1416: SELECT nvl((fnd_number.canonical_to_number(TARGET.result_value)
1417: * FEED.scale),0) tot
1418: FROM pay_run_result_values TARGET
1419: , pay_balance_feeds_f FEED
1420: , pay_run_results RR