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_P45PART3_P46_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 379: l_file_type pay_element_entry_values_f.screen_entry_value%TYPE;

375: l_end_date VARCHAR2(50);
376: l_select_str VARCHAR2(3000);
377: lockingactid NUMBER;
378: l_valid_assg boolean := False;
379: l_file_type pay_element_entry_values_f.screen_entry_value%TYPE;
380: l_submitted pay_element_entry_values_f.screen_entry_value%TYPE;
381: l_element_name varchar2(50);
382: TYPE asg_ref IS REF CURSOR;
383: csr_get_asg asg_ref;

Line 380: l_submitted pay_element_entry_values_f.screen_entry_value%TYPE;

376: l_select_str VARCHAR2(3000);
377: lockingactid NUMBER;
378: l_valid_assg boolean := False;
379: l_file_type pay_element_entry_values_f.screen_entry_value%TYPE;
380: l_submitted pay_element_entry_values_f.screen_entry_value%TYPE;
381: l_element_name varchar2(50);
382: TYPE asg_ref IS REF CURSOR;
383: csr_get_asg asg_ref;
384:

Line 391: pay_element_entry_values_f peev,

387: SELECT nvl(peev.screen_entry_value,'N')
388: FROM pay_element_types_f pet,
389: pay_input_values_f piv,
390: pay_element_entries_f pee,
391: pay_element_entry_values_f peev,
392: per_all_assignments_f paa
393: WHERE pet.element_name='IE P45P3_P46 Information'
394: AND piv.name='P45P3 Or P46 Processed'
395: AND pet.element_type_id=piv.element_type_id

Line 432: pay_element_entry_values_f peev

428: SELECT peev.screen_entry_value P45P3_P46_Processed
429: FROM pay_element_types_f pet,
430: pay_input_values_f piv,
431: pay_element_entries_f pee,
432: pay_element_entry_values_f peev
433: WHERE pet.element_name = 'IE P45P3_P46 Information'
434: and piv.name =c_element_name
435: and pet.legislation_code = 'IE'
436: and piv.element_type_id=pet.element_type_id

Line 464: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';

460: AND scl.segment4 = to_char(g_employer_id)
461: ); */
462:
463: l_ass_check varchar2(1);
464: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';
465: BEGIN
466: hr_utility.set_location('Entering pay_ie_p45p3_p46_pkg.assignment_action_code',220);
467:
468: -- Get all the parameters

Line 592: -- UPDATE pay_element_entry_values_f SET screen_entry_value='Y' WHERE CURRENT OF csr_already_archived;

588: ,pactid => pactid
589: ,chunk => chunk
590: ,greid => NULL);
591: END IF; -- processing of assignment
592: -- UPDATE pay_element_entry_values_f SET screen_entry_value='Y' WHERE CURRENT OF csr_already_archived;
593: --ELSE
594: -- hr_utility.set_location('assignment_action_code, the assignment id finally',980);
595: END IF; -- Already processed assignment check
596:

Line 801: pay_element_entry_values_f peev,

797: SELECT piv.name input_name,peev.screen_entry_value input_value
798: FROM pay_element_types_f pet,
799: pay_input_values_f piv,
800: pay_element_entries_f pee,
801: pay_element_entry_values_f peev,
802: per_all_assignments_f paa,
803: pay_assignment_actions paac
804: WHERE pet.element_name in ('IE P45P3_P46 Information','IE P45 Information')
805: --AND piv.name='P45P3 Or P46 Processed'

Line 863: i_value pay_element_entry_values_f.screen_entry_value%type);

859: where paa1.assignment_id = paa.assignment_id
860: and paa1.effective_start_date between g_start_date and g_end_date );
861:
862: TYPE r_get_assg_detail IS RECORD (i_name pay_input_values_f.name%type,
863: i_value pay_element_entry_values_f.screen_entry_value%type);
864: TYPE t_get_assg_detail IS TABLE OF r_get_assg_detail INDEX BY Binary_Integer;
865: /*
866: CURSOR csr_archive_processed(passactid IN NUMBER) IS
867: SELECT peev.screen_entry_value

Line 871: pay_element_entry_values_f peev,

867: SELECT peev.screen_entry_value
868: from pay_element_types_f pet,
869: pay_input_values_f piv,
870: pay_element_entries_f pee,
871: pay_element_entry_values_f peev,
872: per_all_assignments_f paa,
873: pay_assignment_actions paac
874: WHERE pet.element_name = 'IE P45P3_P46 Information'
875: AND piv.name='P45P3 Or P46 Processed'

Line 888: l_archive_processed pay_element_entry_values_f.screen_entry_value%type;

884: */
885:
886: l_per_emp_start_date varchar2(50);
887:
888: l_archive_processed pay_element_entry_values_f.screen_entry_value%type;
889: l_get_assg_detail t_get_assg_detail;
890: l_person_details csr_person_details%rowtype;
891:
892: i number ;

Line 893: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;

889: l_get_assg_detail t_get_assg_detail;
890: l_person_details csr_person_details%rowtype;
891:
892: i number ;
893: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;

Line 894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;

890: l_person_details csr_person_details%rowtype;
891:
892: i number ;
893: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;

Line 895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;

891:
892: i number ;
893: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;
899: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;

Line 896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;

892: i number ;
893: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;
899: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;
900: l_action_info_id NUMBER(15);

Line 897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;

893: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;
899: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;
900: l_action_info_id NUMBER(15);
901: l_ovn NUMBER;

Line 898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;

894: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;
899: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;
900: l_action_info_id NUMBER(15);
901: l_ovn NUMBER;
902: l_refund varchar2(10);

Line 899: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;

895: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
896: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
897: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
898: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;
899: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;
900: l_action_info_id NUMBER(15);
901: l_ovn NUMBER;
902: l_refund varchar2(10);
903: --bug 13359530

Line 904: l_usc_pay_to_date pay_element_entry_values_f.screen_entry_value%type;

900: l_action_info_id NUMBER(15);
901: l_ovn NUMBER;
902: l_refund varchar2(10);
903: --bug 13359530
904: l_usc_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
905: l_usc_to_date pay_element_entry_values_f.screen_entry_value%type;
906: l_usc_pay_employment pay_element_entry_values_f.screen_entry_value%type;
907: l_usc_employment pay_element_entry_values_f.screen_entry_value%type;
908: l_refund_usc varchar2(10);

Line 905: l_usc_to_date pay_element_entry_values_f.screen_entry_value%type;

901: l_ovn NUMBER;
902: l_refund varchar2(10);
903: --bug 13359530
904: l_usc_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
905: l_usc_to_date pay_element_entry_values_f.screen_entry_value%type;
906: l_usc_pay_employment pay_element_entry_values_f.screen_entry_value%type;
907: l_usc_employment pay_element_entry_values_f.screen_entry_value%type;
908: l_refund_usc varchar2(10);
909:

Line 906: l_usc_pay_employment pay_element_entry_values_f.screen_entry_value%type;

902: l_refund varchar2(10);
903: --bug 13359530
904: l_usc_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
905: l_usc_to_date pay_element_entry_values_f.screen_entry_value%type;
906: l_usc_pay_employment pay_element_entry_values_f.screen_entry_value%type;
907: l_usc_employment pay_element_entry_values_f.screen_entry_value%type;
908: l_refund_usc varchar2(10);
909:
910: -- Bug# 7005067

Line 907: l_usc_employment pay_element_entry_values_f.screen_entry_value%type;

903: --bug 13359530
904: l_usc_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
905: l_usc_to_date pay_element_entry_values_f.screen_entry_value%type;
906: l_usc_pay_employment pay_element_entry_values_f.screen_entry_value%type;
907: l_usc_employment pay_element_entry_values_f.screen_entry_value%type;
908: l_refund_usc varchar2(10);
909:
910: -- Bug# 7005067
911: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;

Line 1142: UPDATE pay_element_entry_values_f set screen_entry_value='Y'

1138:
1139: /*
1140: OPEN csr_archive_processed(p_assactid);
1141: fetch csr_archive_processed into l_archive_processed;
1142: UPDATE pay_element_entry_values_f set screen_entry_value='Y'
1143: WHERE CURRENT OF csr_archive_processed;
1144: close csr_archive_processed;
1145: */ --
1146: hr_utility.set_location('Leaving archive ',20);