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.PAY_IE_P35 dependencies on FND_NUMBER

Line 806: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715

802: IS
803: SELECT /*+ ORDERED USE_NL(asg, paa, ppa, ptp, flex) push_subq */
804: asg.person_id,
805: paa.assignment_id,
806: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,

Line 807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991

803: SELECT /*+ ORDERED USE_NL(asg, paa, ppa, ptp, flex) push_subq */
804: asg.person_id,
805: paa.assignment_id,
806: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,

Line 942: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) desc, -- Bug 4672715

938: AND ppf_p35.soft_coding_keyflex_id = flex_p35.soft_coding_keyflex_id
939: AND flex_p35.segment4 = l_segment4)
940: GROUP BY asg.person_id,paa.assignment_id
941: ORDER BY asg.person_id,
942: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) desc, -- Bug 4672715
943: paa.assignment_id desc;
944:
945: --6633719
946: cursor csr_ppsn_override(p_asg_id number)

Line 1167: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id

1163:
1164: --12382953
1165:
1166: CURSOR csr_action_type (p_assignment_id NUMBER) IS
1167: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1168: , fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min --12382953
1169: FROM pay_assignment_actions paa,
1170: pay_payroll_actions ppa
1171: WHERE ppa.payroll_action_id = paa.payroll_action_id

Line 1168: , fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min --12382953

1164: --12382953
1165:
1166: CURSOR csr_action_type (p_assignment_id NUMBER) IS
1167: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1168: , fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min --12382953
1169: FROM pay_assignment_actions paa,
1170: pay_payroll_actions ppa
1171: WHERE ppa.payroll_action_id = paa.payroll_action_id
1172: and paa.assignment_id = p_assignment_id

Line 2446: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2442:
2443: CURSOR c_get_max_aact(p_pds_id NUMBER,
2444: c_ppsn varchar2,
2445: c_person_id NUMBER) IS
2446: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2447: paa.assignment_action_id),16))
2448: FROM pay_assignment_Actions paa,
2449: pay_payroll_actions ppa
2450:

Line 2586: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2582: WHERE paa.run_type_id = prt.run_type_id
2583: AND prt.run_method IN ('N','P')
2584: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2585: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2586: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2587: paa.assignment_action_id),16)) child_assignment_action_id
2588: FROM pay_assignment_actions paa,
2589: pay_payroll_actions ppa
2590: WHERE paa.assignment_id = p_asg_id

Line 2614: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_max

2610: --12382953
2611:
2612: CURSOR csr_min_max_asg_act_yr (p_assignment_id NUMBER) IS
2613: SELECT
2614: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_max
2615: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min
2616: FROM pay_assignment_actions paa,
2617: pay_payroll_actions ppa
2618: WHERE ppa.payroll_action_id = paa.payroll_action_id

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

2611:
2612: CURSOR csr_min_max_asg_act_yr (p_assignment_id NUMBER) IS
2613: SELECT
2614: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_max
2615: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min
2616: FROM pay_assignment_actions paa,
2617: pay_payroll_actions ppa
2618: WHERE ppa.payroll_action_id = paa.payroll_action_id
2619: and paa.assignment_id = p_assignment_id

Line 7736: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

7732: p_end_date DATE
7733: )
7734: IS
7735: SELECT /*+ ORDERED USE_NL(paa, ppa, ptp)
7736: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
7737: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
7738: FROM per_people_f ppf,
7739: per_assignments_f paf,
7740: pay_assignment_actions paa,