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_FR_DUCS dependencies on HR_ORGANIZATION_INFORMATION

Line 7: hr_organization_information.org_information1%TYPE

3: --
4: -- Globals
5: --
6: type g_org_info_tabtype is table of
7: hr_organization_information.org_information1%TYPE
8: index by binary_integer;
9:
10: type g_estab_pens_prov_rectype is record (
11: estab_id hr_organization_information.organization_id%TYPE,

Line 11: estab_id hr_organization_information.organization_id%TYPE,

7: hr_organization_information.org_information1%TYPE
8: index by binary_integer;
9:
10: type g_estab_pens_prov_rectype is record (
11: estab_id hr_organization_information.organization_id%TYPE,
12: pens_provs g_org_info_tabtype);
13:
14: g_estab_pens_provs g_estab_pens_prov_rectype;
15:

Line 287: , hr_organization_information cmp_check

283: , assact.tax_unit_id establishment_id
284: , payact.action_type
285: FROM pay_assignment_actions assact
286: , pay_payroll_actions payact
287: , hr_organization_information cmp_check
288: WHERE assact.source_action_id is null
289: AND assact.action_status = 'C'
290: AND assact.payroll_action_id = payact.payroll_action_id
291: AND payact.effective_date between g_period_start_date

Line 331: , hr_organization_information cmp_check

327: , per_periods_of_service pos
328: , per_all_assignments_f asg
329: , pay_assignment_actions assact
330: , pay_payroll_actions payact
331: , hr_organization_information cmp_check
332: WHERE pop.payroll_action_id = p_payroll_action_id
333: and pop.chunk_number = p_chunk
334: and asg.business_group_id+0 = g_business_group_id
335: and asg.effective_end_date >= g_period_start_date

Line 787: FROM hr_organization_information

783: -- Cursor to retrieve the pension provider id
784: --
785: CURSOR cestpens(p_Order_Number varchar2) is
786: SELECT org_information1 -- Org ID of Pension Provider
787: FROM hr_organization_information
788: WHERE organization_id = l_establishment_id
789: and org_information4 = p_Order_Number
790: and org_information_context = 'FR_ESTAB_PE_PRVS';
791: --

Line 1229: FROM hr_organization_information pens_prv

1225: and contrib.action_context_type = 'AAP'
1226: and assact.assignment_action_id = contrib.action_context_id
1227: and ((contrib.action_information1 in
1228: (SELECT pens_prv.org_information1
1229: FROM hr_organization_information pens_prv
1230: WHERE pens_prv.org_information_id = p_page_identifier
1231: AND pens_prv.org_information_context = 'FR_COMP_PE_PRVS'))
1232: or
1233: (contrib.action_information1 in

Line 1235: FROM hr_organization_information ind_pens_prv

1231: AND pens_prv.org_information_context = 'FR_COMP_PE_PRVS'))
1232: or
1233: (contrib.action_information1 in
1234: (SELECT fnd_number.number_to_canonical(ind_pens_prv.organization_id)
1235: FROM hr_organization_information ind_pens_prv
1236: , hr_organization_information pens_grp
1237: WHERE pens_grp.org_information_id = p_page_identifier
1238: AND pens_grp.org_information_context = 'FR_COMP_PE_PRVS'
1239: AND ind_pens_prv.org_information3 = pens_grp.org_information1

Line 1236: , hr_organization_information pens_grp

1232: or
1233: (contrib.action_information1 in
1234: (SELECT fnd_number.number_to_canonical(ind_pens_prv.organization_id)
1235: FROM hr_organization_information ind_pens_prv
1236: , hr_organization_information pens_grp
1237: WHERE pens_grp.org_information_id = p_page_identifier
1238: AND pens_grp.org_information_context = 'FR_COMP_PE_PRVS'
1239: AND ind_pens_prv.org_information3 = pens_grp.org_information1
1240: AND ind_pens_prv.org_information_context = 'FR_PE_PRV_INFO')))

Line 1385: FROM hr_organization_information

1381: l_pension_provider_id := rec_contr.subpage_identifier;
1382: BEGIN
1383: SELECT org_information1
1384: INTO l_pension_provider
1385: FROM hr_organization_information
1386: WHERE organization_id = l_pension_provider_id
1387: AND org_information_context = 'FR_PE_PRV_INFO';
1388: EXCEPTION
1389: WHEN no_data_found THEN

Line 1479: l_payment_1_account hr_organization_information.org_information3%TYPE;

1475:
1476: l_org_information_id number;
1477: l_object_version_number number;
1478:
1479: l_payment_1_account hr_organization_information.org_information3%TYPE;
1480: l_payment_1_type hr_organization_information.org_information4%TYPE;
1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;

Line 1480: l_payment_1_type hr_organization_information.org_information4%TYPE;

1476: l_org_information_id number;
1477: l_object_version_number number;
1478:
1479: l_payment_1_account hr_organization_information.org_information3%TYPE;
1480: l_payment_1_type hr_organization_information.org_information4%TYPE;
1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;

Line 1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;

1477: l_object_version_number number;
1478:
1479: l_payment_1_account hr_organization_information.org_information3%TYPE;
1480: l_payment_1_type hr_organization_information.org_information4%TYPE;
1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;

Line 1482: l_payment_2_account hr_organization_information.org_information6%TYPE;

1478:
1479: l_payment_1_account hr_organization_information.org_information3%TYPE;
1480: l_payment_1_type hr_organization_information.org_information4%TYPE;
1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;
1486: l_payment_3_type hr_organization_information.org_information10%TYPE;

Line 1483: l_payment_2_type hr_organization_information.org_information7%TYPE;

1479: l_payment_1_account hr_organization_information.org_information3%TYPE;
1480: l_payment_1_type hr_organization_information.org_information4%TYPE;
1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;
1486: l_payment_3_type hr_organization_information.org_information10%TYPE;
1487: l_payment_3_limit hr_organization_information.org_information11%TYPE;

Line 1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;

1480: l_payment_1_type hr_organization_information.org_information4%TYPE;
1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;
1486: l_payment_3_type hr_organization_information.org_information10%TYPE;
1487: l_payment_3_limit hr_organization_information.org_information11%TYPE;
1488: l_advances number;

Line 1485: l_payment_3_account hr_organization_information.org_information9%TYPE;

1481: l_payment_1_limit hr_organization_information.org_information5%TYPE;
1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;
1486: l_payment_3_type hr_organization_information.org_information10%TYPE;
1487: l_payment_3_limit hr_organization_information.org_information11%TYPE;
1488: l_advances number;
1489: l_regularization number;

Line 1486: l_payment_3_type hr_organization_information.org_information10%TYPE;

1482: l_payment_2_account hr_organization_information.org_information6%TYPE;
1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;
1486: l_payment_3_type hr_organization_information.org_information10%TYPE;
1487: l_payment_3_limit hr_organization_information.org_information11%TYPE;
1488: l_advances number;
1489: l_regularization number;
1490: l_payment_1_acc_no varchar2(60);

Line 1487: l_payment_3_limit hr_organization_information.org_information11%TYPE;

1483: l_payment_2_type hr_organization_information.org_information7%TYPE;
1484: l_payment_2_limit hr_organization_information.org_information8%TYPE;
1485: l_payment_3_account hr_organization_information.org_information9%TYPE;
1486: l_payment_3_type hr_organization_information.org_information10%TYPE;
1487: l_payment_3_limit hr_organization_information.org_information11%TYPE;
1488: l_advances number;
1489: l_regularization number;
1490: l_payment_1_acc_no varchar2(60);
1491: l_payment_2_acc_no varchar2(60);

Line 1553: , hr_organization_information comp_info

1549: , comp_rep_info.ORG_INFORMATION11 Administrator_Telephone_Number
1550: , comp_rep_info.ORG_INFORMATION12 Administrator_FAX_Number
1551: FROM hr_all_organization_units o
1552: , hr_locations l
1553: , hr_organization_information comp_info
1554: , hr_organization_information rep_estab_info
1555: , hr_organization_information comp_rep_info
1556: WHERE o.organization_id = g_company_id
1557: and o.location_id = l.location_id (+)

Line 1554: , hr_organization_information rep_estab_info

1550: , comp_rep_info.ORG_INFORMATION12 Administrator_FAX_Number
1551: FROM hr_all_organization_units o
1552: , hr_locations l
1553: , hr_organization_information comp_info
1554: , hr_organization_information rep_estab_info
1555: , hr_organization_information comp_rep_info
1556: WHERE o.organization_id = g_company_id
1557: and o.location_id = l.location_id (+)
1558: and comp_info.organization_id (+) = o.organization_id

Line 1555: , hr_organization_information comp_rep_info

1551: FROM hr_all_organization_units o
1552: , hr_locations l
1553: , hr_organization_information comp_info
1554: , hr_organization_information rep_estab_info
1555: , hr_organization_information comp_rep_info
1556: WHERE o.organization_id = g_company_id
1557: and o.location_id = l.location_id (+)
1558: and comp_info.organization_id (+) = o.organization_id
1559: and comp_info.org_information_context (+) = 'FR_COMP_INFO'

Line 1627: FROM hr_organization_information estab_info

1623: , substr(assedic_loc.address_line_1,1,150) assedic_address_line_1
1624: , substr(assedic_loc.address_line_2,1,150) assedic_address_line_2
1625: , substr(assedic_loc.region_3,1,150) assedic_address_line_3
1626: , assedic_loc.postal_code||' '||assedic_loc.town_or_city assedic_address_line_4
1627: FROM hr_organization_information estab_info
1628: , hr_organization_information estab_urssaf_info
1629: , hr_organization_information estab_assedic_info
1630: , hr_organization_information estab_rep_info
1631: , hr_all_organization_units urssaf

Line 1628: , hr_organization_information estab_urssaf_info

1624: , substr(assedic_loc.address_line_2,1,150) assedic_address_line_2
1625: , substr(assedic_loc.region_3,1,150) assedic_address_line_3
1626: , assedic_loc.postal_code||' '||assedic_loc.town_or_city assedic_address_line_4
1627: FROM hr_organization_information estab_info
1628: , hr_organization_information estab_urssaf_info
1629: , hr_organization_information estab_assedic_info
1630: , hr_organization_information estab_rep_info
1631: , hr_all_organization_units urssaf
1632: , hr_all_organization_units assedic

Line 1629: , hr_organization_information estab_assedic_info

1625: , substr(assedic_loc.region_3,1,150) assedic_address_line_3
1626: , assedic_loc.postal_code||' '||assedic_loc.town_or_city assedic_address_line_4
1627: FROM hr_organization_information estab_info
1628: , hr_organization_information estab_urssaf_info
1629: , hr_organization_information estab_assedic_info
1630: , hr_organization_information estab_rep_info
1631: , hr_all_organization_units urssaf
1632: , hr_all_organization_units assedic
1633: , hr_locations_all urssaf_loc

Line 1630: , hr_organization_information estab_rep_info

1626: , assedic_loc.postal_code||' '||assedic_loc.town_or_city assedic_address_line_4
1627: FROM hr_organization_information estab_info
1628: , hr_organization_information estab_urssaf_info
1629: , hr_organization_information estab_assedic_info
1630: , hr_organization_information estab_rep_info
1631: , hr_all_organization_units urssaf
1632: , hr_all_organization_units assedic
1633: , hr_locations_all urssaf_loc
1634: , hr_locations_all assedic_loc

Line 1685: FROM hr_organization_information pens_prov_info

1681: , pens_prov_info.ORG_INFORMATION12 Payment_2_Limit
1682: , pens_prov_info.ORG_INFORMATION13 Payment_3_Account
1683: , pens_prov_info.ORG_INFORMATION14 Payment_3_Type
1684: , pens_prov_info.ORG_INFORMATION15 Payment_3_Limit
1685: FROM hr_organization_information pens_prov_info
1686: , hr_all_organization_units pens_prov
1687: , hr_locations_all pens_loc
1688: WHERE pens_prov_info.organization_id = g_company_id
1689: and pens_prov_info.org_information_context = 'FR_COMP_PE_PRVS'

Line 1723: FROM hr_organization_information

1719: , org_information14 payment_3_type
1720: , org_information15 payment_3_limit
1721: , fnd_number.canonical_to_number(org_information16) advances
1722: , fnd_number.canonical_to_number(org_information17) regularisation
1723: FROM hr_organization_information
1724: WHERE organization_id = g_company_id
1725: and org_information_context = 'FR_COMP_PAYMENT_OVERRIDE'
1726: and org_information2 = p_page_identifier
1727: and org_information4 = p_page_type;

Line 1804: DELETE FROM hr_organization_information

1800: ,'FR_DUCS_CONTRIB_INFO');
1801:
1802: -- Delete any payment override information from previous periods
1803:
1804: DELETE FROM hr_organization_information
1805: WHERE organization_id = g_company_id
1806: AND org_information_context = 'FR_COMP_PAYMENT_OVERRIDE'
1807: AND org_information1 <> p_payroll_action_id;
1808:

Line 2458: FROM hr_organization_information payment

2454: , page.action_information_id
2455: , page.object_version_number
2456: , page.action_information4 organization_name
2457: , page.action_information25 total_contributions
2458: FROM hr_organization_information payment
2459: , pay_action_information page
2460: WHERE payment.organization_id = p_company_id
2461: and payment.org_information3 =
2462: to_char(l_period_end_date,'YY') ||