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_FI_ARCHIVE_UMFR dependencies on PAY_BALANCE_PKG

Line 1412: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

1408: FETCH csr_person_details INTO lr_person_details;
1409: CLOSE csr_person_details;
1410: l_employee_name := lr_person_details.NAME;
1411: l_employee_pin := lr_person_details.national_identifier;
1412: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);
1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);

Line 1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);

1409: CLOSE csr_person_details;
1410: l_employee_name := lr_person_details.NAME;
1411: l_employee_pin := lr_person_details.national_identifier;
1412: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);
1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));

1410: l_employee_name := lr_person_details.NAME;
1411: l_employee_pin := lr_person_details.national_identifier;
1412: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);
1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);

Line 1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

1411: l_employee_pin := lr_person_details.national_identifier;
1412: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);
1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);
1419: pay_balance_pkg.set_context('ASSIGNMENT_ID',lr_person_details.assignment_id);

Line 1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);

1412: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);
1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);
1419: pay_balance_pkg.set_context('ASSIGNMENT_ID',lr_person_details.assignment_id);
1420:

Line 1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);

1413: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id_fetched);
1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);
1419: pay_balance_pkg.set_context('ASSIGNMENT_ID',lr_person_details.assignment_id);
1420:
1421: if g_period='MONTH' THEN

Line 1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);

1414: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_period_end_date));
1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);
1419: pay_balance_pkg.set_context('ASSIGNMENT_ID',lr_person_details.assignment_id);
1420:
1421: if g_period='MONTH' THEN
1422:

Line 1419: pay_balance_pkg.set_context('ASSIGNMENT_ID',lr_person_details.assignment_id);

1415: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
1416: pay_balance_pkg.set_context('SOURCE_ID',NULL);
1417: pay_balance_pkg.set_context('TAX_GROUP',NULL);
1418: pay_balance_pkg.set_context('ORGANIZATION_ID',g_trade_union_id);
1419: pay_balance_pkg.set_context('ASSIGNMENT_ID',lr_person_details.assignment_id);
1420:
1421: if g_period='MONTH' THEN
1422:
1423:

Line 1428: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1424: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_MONTH');
1425: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1426: CLOSE csr_Get_Defined_Balance_Id;
1427:
1428: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1429: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_MONTH');
1430: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1431: CLOSE csr_Get_Defined_Balance_Id;
1432:

Line 1433: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1429: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_MONTH');
1430: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1431: CLOSE csr_Get_Defined_Balance_Id;
1432:
1433: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1434:
1435: elsif g_period='BIMONTH' THEN
1436: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_BIMONTH');
1437: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 1440: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1436: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_BIMONTH');
1437: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1438: CLOSE csr_Get_Defined_Balance_Id;
1439:
1440: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1441: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_BIMONTH');
1442: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1443: CLOSE csr_Get_Defined_Balance_Id;
1444:

Line 1445: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1441: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_BIMONTH');
1442: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1443: CLOSE csr_Get_Defined_Balance_Id;
1444:
1445: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1446:
1447:
1448: elsif g_period='BIWEEK' THEN
1449: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_BIWEEK');

Line 1453: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1449: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_BIWEEK');
1450: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1451: CLOSE csr_Get_Defined_Balance_Id;
1452:
1453: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1454: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_BIWEEK');
1455: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1456: CLOSE csr_Get_Defined_Balance_Id;
1457:

Line 1458: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1454: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_BIWEEK');
1455: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1456: CLOSE csr_Get_Defined_Balance_Id;
1457:
1458: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1459:
1460:
1461: elsif g_period='QUARTER' THEN
1462: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_QUARTER');

Line 1466: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1462: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_UNION_LU_QUARTER');
1463: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1464: CLOSE csr_Get_Defined_Balance_Id;
1465:
1466: l_union_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1467: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_QUARTER');
1468: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1469: CLOSE csr_Get_Defined_Balance_Id;
1470:

Line 1471: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );

1467: OPEN csr_Get_Defined_Balance_Id( 'UNION_DUES_NEGATIVE_PAYMENT_PER_UNION_LU_QUARTER');
1468: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1469: CLOSE csr_Get_Defined_Balance_Id;
1470:
1471: l_negative_per_lu :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_period_end_date );
1472:
1473:
1474: END IF;
1475:

Line 1479: -- l_Union_Dues := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, lr_Person_Details.assignment_id,p_effective_date);

1475:
1476:
1477: -- Pick up the defined balance id belonging to CUMULATIVE_TRADE_UNION_MEMBERSHIP_FEES_PER_PTD
1478: -- End of Pickingup the Data
1479: -- l_Union_Dues := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, lr_Person_Details.assignment_id,p_effective_date);
1480:
1481: IF l_negative_per_lu > 0
1482: THEN
1483: l_Sign_of_payment := '-';