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

Line 263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

259: ,g_version
260: ,g_archive
261: );
262:
263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
266: pay_balance_pkg.set_context('SOURCE_ID',NULL);
267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/

Line 264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);

260: ,g_archive
261: );
262:
263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
266: pay_balance_pkg.set_context('SOURCE_ID',NULL);
267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/
268:

Line 265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));

261: );
262:
263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
266: pay_balance_pkg.set_context('SOURCE_ID',NULL);
267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/
268:
269: IF g_archive = 'Y'

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

262:
263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
266: pay_balance_pkg.set_context('SOURCE_ID',NULL);
267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/
268:
269: IF g_archive = 'Y'
270: THEN

Line 267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/

263: /* pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
264: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
265: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_ref_date));
266: pay_balance_pkg.set_context('SOURCE_ID',NULL);
267: pay_balance_pkg.set_context('TAX_GROUP',NULL);*/
268:
269: IF g_archive = 'Y'
270: THEN
271:

Line 776: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0010');

772: l_ptd_defined_balance_id := get_defined_balance_id('SUMMED_RESULTS_ASG_ELE_CODE_PTD');
773: l_ytd_defined_balance_id := get_defined_balance_id('SUMMED_RESULTS_ASG_ELE_CODE_YTD');
774: l_pyqtd_defined_balance_id := get_defined_balance_id('SUMMED_RESULTS_ASG_ELE_CODE_PYLQ');
775:
776: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0010');
777:
778: begin
779: l_ssb_code_0010_ptd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ptd_defined_balance_id,
780: p_assignment_id => l_asg_rec.assignment_id,

Line 779: l_ssb_code_0010_ptd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ptd_defined_balance_id,

775:
776: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0010');
777:
778: begin
779: l_ssb_code_0010_ptd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ptd_defined_balance_id,
780: p_assignment_id => l_asg_rec.assignment_id,
781: p_virtual_date => l_effective_date),'999999999D99') ;
782: exception
783: when no_data_found then

Line 788: l_ssb_code_0010_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

784: null;
785: end;
786:
787: begin
788: l_ssb_code_0010_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
789: p_assignment_id => l_asg_rec.assignment_id,
790: p_virtual_date => l_effective_date),'999999999D99') ;
791: exception
792: when no_data_found then

Line 796: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0020');

792: when no_data_found then
793: null;
794: end;
795:
796: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0020');
797: begin
798: l_ssb_code_0020_ptd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ptd_defined_balance_id,
799: p_assignment_id => l_asg_rec.assignment_id,
800: p_virtual_date => l_effective_date),'999999999D99') ;

Line 798: l_ssb_code_0020_ptd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ptd_defined_balance_id,

794: end;
795:
796: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0020');
797: begin
798: l_ssb_code_0020_ptd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ptd_defined_balance_id,
799: p_assignment_id => l_asg_rec.assignment_id,
800: p_virtual_date => l_effective_date),'999999999D99') ;
801: exception
802: when no_data_found then

Line 808: l_ssb_code_0020_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

804: end;
805:
806:
807: begin
808: l_ssb_code_0020_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
809: p_assignment_id => l_asg_rec.assignment_id,
810: p_virtual_date => l_effective_date),'999999999D99') ;
811: exception
812: when no_data_found then

Line 827: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0030');

823: FETCH csr_year_add_info_result INTO l_ssb_code_0010_hrs_ytd;
824: CLOSE csr_year_add_info_result;
825:
826:
827: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0030');
828: begin
829: l_ssb_code_0030_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
830: p_assignment_id => l_asg_rec.assignment_id,
831: p_virtual_date => l_effective_date),'999999999D99') ;

Line 829: l_ssb_code_0030_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

825:
826:
827: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0030');
828: begin
829: l_ssb_code_0030_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
830: p_assignment_id => l_asg_rec.assignment_id,
831: p_virtual_date => l_effective_date),'999999999D99') ;
832: exception
833: when no_data_found then

Line 837: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0035');

833: when no_data_found then
834: null;
835: end;
836:
837: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0035');
838: begin
839: l_ssb_code_0035_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
840: p_assignment_id => l_asg_rec.assignment_id,
841: p_virtual_date => l_effective_date),'999999999D99') ;

Line 839: l_ssb_code_0035_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

835: end;
836:
837: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0035');
838: begin
839: l_ssb_code_0035_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
840: p_assignment_id => l_asg_rec.assignment_id,
841: p_virtual_date => l_effective_date),'999999999D99') ;
842:
843: exception

Line 852: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0037');

848: OPEN csr_year_add_info_result(l_asg_rec.assignment_id,'SSB CODE 0035',l_effective_date);
849: FETCH csr_year_add_info_result INTO l_ssb_code_0035_hrs_ytd;
850: CLOSE csr_year_add_info_result;
851:
852: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0037');
853: begin
854: l_ssb_code_0037_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
855: p_assignment_id => l_asg_rec.assignment_id,
856: p_virtual_date => l_effective_date),'999999999D99') ;

Line 854: l_ssb_code_0037_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

850: CLOSE csr_year_add_info_result;
851:
852: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0037');
853: begin
854: l_ssb_code_0037_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
855: p_assignment_id => l_asg_rec.assignment_id,
856: p_virtual_date => l_effective_date),'999999999D99') ;
857: exception
858: when no_data_found then

Line 862: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0038');

858: when no_data_found then
859: null;
860: end;
861:
862: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0038');
863: begin
864: l_ssb_code_0038_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
865: p_assignment_id => l_asg_rec.assignment_id,
866: p_virtual_date => l_effective_date),'999999999D99') ;

Line 864: l_ssb_code_0038_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

860: end;
861:
862: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0038');
863: begin
864: l_ssb_code_0038_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
865: p_assignment_id => l_asg_rec.assignment_id,
866: p_virtual_date => l_effective_date),'999999999D99') ;
867: exception
868: when no_data_found then

Line 873: l_ssb_code_0038_pyqtd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_pyqtd_defined_balance_id,

869: null;
870: end;
871:
872: begin
873: l_ssb_code_0038_pyqtd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_pyqtd_defined_balance_id,
874: p_assignment_id => l_asg_rec.assignment_id,
875: p_virtual_date => l_effective_date),'999999999D99') ;
876: exception
877: when no_data_found then

Line 881: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0040');

877: when no_data_found then
878: null;
879: end;
880:
881: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0040');
882: begin
883: l_ssb_code_0040_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
884: p_assignment_id => l_asg_rec.assignment_id,
885: p_virtual_date => l_effective_date),'999999999D99') ;

Line 883: l_ssb_code_0040_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

879: end;
880:
881: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0040');
882: begin
883: l_ssb_code_0040_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
884: p_assignment_id => l_asg_rec.assignment_id,
885: p_virtual_date => l_effective_date),'999999999D99') ;
886: exception
887: when no_data_found then

Line 891: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0041');

887: when no_data_found then
888: null;
889: end;
890:
891: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0041');
892: begin
893: l_ssb_code_0041_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
894: p_assignment_id => l_asg_rec.assignment_id,
895: p_virtual_date => l_effective_date),'999999999D99') ;

Line 893: l_ssb_code_0041_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,

889: end;
890:
891: pay_balance_pkg.set_context('SOURCE_TEXT','SSB CODE 0041');
892: begin
893: l_ssb_code_0041_ytd := to_char(pay_balance_pkg.get_value(p_defined_balance_id => l_ytd_defined_balance_id,
894: p_assignment_id => l_asg_rec.assignment_id,
895: p_virtual_date => l_effective_date),'999999999D99') ;
896: exception
897: when no_data_found then