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 1222: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

1218: ( p_assignment_id NUMBER
1219: ,p_date_earned DATE
1220: )
1221: IS
1222: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1223: --paa.assignment_action_id
1224: FROM pay_assignment_actions paa
1225: ,pay_payroll_actions ppa
1226: WHERE paa.assignment_id = p_assignment_id

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

1269: ,p_asg_act_id NUMBER
1270: ,p_balance_type_id NUMBER
1271: )
1272: IS
1273: SELECT fnd_number.canonical_to_number(TARGET.result_value) result
1274: ,nvl(RR.start_date,p_start_date) start_date
1275: ,nvl(RR.end_date,p_end_date) end_date
1276: ,FEED.scale scale
1277: ,RR.run_result_id

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

1410: ,p_effective_start_date DATE
1411: ,p_effective_end_date DATE
1412: )IS
1413:
1414: SELECT fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1415: ,ppa.date_earned
1416: FROM pay_assignment_actions paa
1417: ,pay_payroll_actions ppa
1418: WHERE paa.assignment_id = p_assignment_id

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

1423: AND ppa.date_earned BETWEEN p_effective_start_date
1424: AND p_effective_end_date
1425: AND (paa.source_action_id IS NOT NULL OR ppa.action_type in ('B','I'))
1426: GROUP BY ppa.date_earned
1427: ORDER BY fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) ;
1428:
1429: -- Get the assignment action id for child assignment actions
1430: CURSOR csr_get_asg_act_id_dw
1431: ( p_assignment_id NUMBER

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

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

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

1989: p_assignment_action_id NUMBER,
1990: p_start_date DATE,
1991: p_end_date DATE
1992: ) IS
1993: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
1994: /* Assignment with Date worked for Run */
1995: FROM pay_assignment_actions BAL_ASSACT
1996: ,pay_payroll_actions BACT
1997: ,pay_assignment_actions ASSACT

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

2027: p_assignment_id NUMBER,
2028: p_start_date DATE,
2029: p_end_date DATE
2030: ) IS
2031: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2032: /* Assignment with Date worked for Run */
2033: FROM pay_assignment_actions ASSACT
2034: ,pay_payroll_actions PACT
2035: ,pay_run_results RR