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_MX_PAYREG_PKG dependencies on FND_NUMBER

Line 885: SELECT fnd_number.canonical_to_number(value1)

881: AND legislation_code = 'MX';
882:
883: CURSOR c_get_assig_act_id (pactid number
884: ,assigactid number) is
885: SELECT fnd_number.canonical_to_number(value1)
886: FROM pay_us_rpt_totals
887: WHERE session_id = fnd_number.number_to_canonical(pactid)
888: AND location_id = fnd_number.number_to_canonical(assigactid)
889: AND attribute30 = 'MX_PYR';

Line 887: WHERE session_id = fnd_number.number_to_canonical(pactid)

883: CURSOR c_get_assig_act_id (pactid number
884: ,assigactid number) is
885: SELECT fnd_number.canonical_to_number(value1)
886: FROM pay_us_rpt_totals
887: WHERE session_id = fnd_number.number_to_canonical(pactid)
888: AND location_id = fnd_number.number_to_canonical(assigactid)
889: AND attribute30 = 'MX_PYR';
890:
891: CURSOR c_get_assig_id (pactid number

Line 888: AND location_id = fnd_number.number_to_canonical(assigactid)

884: ,assigactid number) is
885: SELECT fnd_number.canonical_to_number(value1)
886: FROM pay_us_rpt_totals
887: WHERE session_id = fnd_number.number_to_canonical(pactid)
888: AND location_id = fnd_number.number_to_canonical(assigactid)
889: AND attribute30 = 'MX_PYR';
890:
891: CURSOR c_get_assig_id (pactid number
892: ,assigactid number) is

Line 893: SELECT DISTINCT fnd_number.canonical_to_number(value2)

889: AND attribute30 = 'MX_PYR';
890:
891: CURSOR c_get_assig_id (pactid number
892: ,assigactid number) is
893: SELECT DISTINCT fnd_number.canonical_to_number(value2)
894: FROM pay_us_rpt_totals
895: WHERE session_id = fnd_number.number_to_canonical(pactid)
896: AND location_id = fnd_number.number_to_canonical(assigactid)
897: AND attribute30 = 'MX_PYR';

Line 895: WHERE session_id = fnd_number.number_to_canonical(pactid)

891: CURSOR c_get_assig_id (pactid number
892: ,assigactid number) is
893: SELECT DISTINCT fnd_number.canonical_to_number(value2)
894: FROM pay_us_rpt_totals
895: WHERE session_id = fnd_number.number_to_canonical(pactid)
896: AND location_id = fnd_number.number_to_canonical(assigactid)
897: AND attribute30 = 'MX_PYR';
898:
899: CURSOR c_get_def_bal_id is

Line 896: AND location_id = fnd_number.number_to_canonical(assigactid)

892: ,assigactid number) is
893: SELECT DISTINCT fnd_number.canonical_to_number(value2)
894: FROM pay_us_rpt_totals
895: WHERE session_id = fnd_number.number_to_canonical(pactid)
896: AND location_id = fnd_number.number_to_canonical(assigactid)
897: AND attribute30 = 'MX_PYR';
898:
899: CURSOR c_get_def_bal_id is
900: SELECT DISTINCT fue_live.user_entity_name,

Line 1228: WHERE greghn.entity_id = fnd_number.number_to_canonical(cp_tax_unit_id)

1224: SELECT hou.name
1225: FROM hr_organization_units hou,
1226: per_gen_hierarchy_nodes greghn,
1227: per_gen_hierarchy_nodes leghn
1228: WHERE greghn.entity_id = fnd_number.number_to_canonical(cp_tax_unit_id)
1229: AND leghn.hierarchy_node_id = greghn.parent_hierarchy_node_id
1230: AND hou.organization_id = leghn.entity_id;
1231:
1232: CURSOR c_get_assig_set_id (cp_assignment_set_id NUMBER) IS

Line 1262: WHERE attribute1 = fnd_number.number_to_canonical(c_payroll_action_id)

1258: CURSOR csr_get_le_tot(c_payroll_action_id NUMBER) IS
1259: SELECT attribute5 balance_name
1260: ,sum(value1) total
1261: FROM pay_us_rpt_totals
1262: WHERE attribute1 = fnd_number.number_to_canonical(c_payroll_action_id)
1263: AND attribute30 = 'MX_PYR'
1264: GROUP BY attribute5;
1265:
1266: lv_buf VARCHAR2(2000);

Line 1447: AND attribute1 = fnd_number.number_to_canonical(c_payroll_action_id)

1443: SELECT attribute5 balance_name
1444: ,sum(value1) total
1445: FROM pay_us_rpt_totals
1446: WHERE tax_unit_id = c_tax_unit_id
1447: AND attribute1 = fnd_number.number_to_canonical(c_payroll_action_id)
1448: AND attribute30 = 'MX_PYR'
1449: GROUP BY attribute5;
1450:
1451: lv_buf VARCHAR2(8000);