eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on FND_NUMBER

Line 1243: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

1239: ( p_assignment_id NUMBER
1240: ,p_date_earned DATE
1241: )
1242: IS
1243: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1244: --paa.assignment_action_id
1245: FROM pay_assignment_actions paa
1246: ,pay_payroll_actions ppa
1247: WHERE paa.assignment_id = p_assignment_id

Line 1294: SELECT fnd_number.canonical_to_number(TARGET.result_value) result

1290: ,p_asg_act_id NUMBER
1291: ,p_balance_type_id NUMBER
1292: )
1293: IS
1294: SELECT fnd_number.canonical_to_number(TARGET.result_value) result
1295: ,nvl(RR.start_date,p_start_date) start_date
1296: ,nvl(RR.end_date,p_end_date) end_date
1297: ,FEED.scale scale
1298: ,RR.run_result_id

Line 1435: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

1431: ,p_effective_start_date DATE
1432: ,p_effective_end_date DATE
1433: )IS
1434:
1435: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1436: ,ppa.date_earned
1437: FROM pay_assignment_actions paa
1438: ,pay_payroll_actions ppa
1439: WHERE paa.assignment_id = p_assignment_id

Line 1448: ORDER BY fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) ;

1444: AND ppa.date_earned BETWEEN p_effective_start_date
1445: AND p_effective_end_date
1446: AND (paa.source_action_id IS NOT NULL OR ppa.action_type in ('B','I'))
1447: GROUP BY ppa.date_earned
1448: ORDER BY fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) ;
1449:
1450: -- Get the assignment action id for child assignment actions
1451: CURSOR csr_get_asg_act_id_dw
1452: ( p_assignment_id NUMBER

Line 1457: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

1453: ,p_effective_start_date DATE
1454: ,p_effective_end_date DATE
1455: )
1456: IS
1457: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1458: ,ppa.date_earned
1459: FROM pay_assignment_actions paa
1460: ,pay_payroll_actions ppa
1461: WHERE paa.assignment_id = p_assignment_id

Line 2021: SELECT /+ ORDERED /nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

2017: p_assignment_action_id NUMBER,
2018: p_start_date DATE,
2019: p_end_date DATE
2020: ) IS
2021: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2022: /* Assignment with Date worked for Run */
2023: FROM pay_assignment_actions BAL_ASSACT
2024: ,pay_payroll_actions BACT
2025: ,pay_assignment_actions ASSACT

Line 2065: SELECT /+ ORDERED /nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

2061: p_assignment_id NUMBER,
2062: p_start_date DATE,
2063: p_end_date DATE
2064: ) IS
2065: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2066: /* Assignment with Date worked for Run */
2067: FROM pay_assignment_actions ASSACT
2068: ,pay_payroll_actions PACT
2069: ,pay_run_results RR