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 376: l_file_type pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 377: l_submitted pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 388: pay_element_entry_values_f peev,

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

Line 429: pay_element_entry_values_f peev

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

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

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

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

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

Line 798: pay_element_entry_values_f peev,

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

Line 860: i_value pay_element_entry_values_f.screen_entry_value%type);

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

Line 868: pay_element_entry_values_f peev,

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

Line 885: l_archive_processed pay_element_entry_values_f.screen_entry_value%type;

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

Line 890: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;

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

Line 891: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;

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

Line 892: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;

888:
889: i number ;
890: l_pay_to_date pay_element_entry_values_f.screen_entry_value%type;
891: l_tax_to_date pay_element_entry_values_f.screen_entry_value%type;
892: l_pay_employment pay_element_entry_values_f.screen_entry_value%type;
893: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;
894: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;
895: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;
896: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;

Line 893: l_tax_employment pay_element_entry_values_f.screen_entry_value%type;

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

Line 894: l_paye_employer pay_element_entry_values_f.screen_entry_value%type;

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

Line 895: l_emp_start_date pay_element_entry_values_f.screen_entry_value%type;

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

Line 896: l_emp_end_date pay_element_entry_values_f.screen_entry_value%type;

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

Line 1116: UPDATE pay_element_entry_values_f set screen_entry_value='Y'

1112:
1113: /*
1114: OPEN csr_archive_processed(p_assactid);
1115: fetch csr_archive_processed into l_archive_processed;
1116: UPDATE pay_element_entry_values_f set screen_entry_value='Y'
1117: WHERE CURRENT OF csr_archive_processed;
1118: close csr_archive_processed;
1119: */ --
1120: hr_utility.set_location('Leaving archive ',20);