APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PER_ALL_ASSIGNMENTS_F

Line 6: assignmnet_number per_all_assignments_f.assignment_number%type,

2: /* $Header: pydkeholreq.pkb 120.0.12020000.2 2012/07/18 06:52:00 rsahai noship $ */
3:
4:
5: TYPE hol_card_emp IS RECORD ( emp_name per_all_people_f.full_name%type,
6: assignmnet_number per_all_assignments_f.assignment_number%type,
7: cpr_number per_all_people_f.national_identifier%type,
8: hire_date varchar2(50) ,
9: start_date varchar2(15),
10: no_of_hol varchar2(5) ,

Line 35: p_assg_number per_all_assignments_f.assignment_number%type,

31: g_vendor_id varchar2(25);
32:
33: TYPE error_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,
34: -- p_cpr_number per_all_people_f.national_identifier%type,
35: p_assg_number per_all_assignments_f.assignment_number%type,
36: p_err_msg VARCHAR2(1000),
37: p_absence_start date,
38: p_duration number);
39:

Line 47: p_assg_number per_all_assignments_f.assignment_number%type,

43: err_cnt number := 1;
44:
45: TYPE process_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,
46: -- p_cpr_number per_all_people_f.national_identifier%type,
47: p_assg_number per_all_assignments_f.assignment_number%type,
48: p_proc_msg VARCHAR2(1000),
49: p_absence_start date,
50: p_duration number);
51:

Line 129: FROM per_all_assignments_f asg1

125: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
126: SELECT ee.element_entry_id element_entry_id
127: , eev1.screen_entry_value screen_entry_value
128: , iv1.name
129: FROM per_all_assignments_f asg1
130: ,per_all_assignments_f asg2
131: ,per_all_people_f per
132: ,pay_element_links_f el
133: ,pay_element_types_f et

Line 130: ,per_all_assignments_f asg2

126: SELECT ee.element_entry_id element_entry_id
127: , eev1.screen_entry_value screen_entry_value
128: , iv1.name
129: FROM per_all_assignments_f asg1
130: ,per_all_assignments_f asg2
131: ,per_all_people_f per
132: ,pay_element_links_f el
133: ,pay_element_types_f et
134: ,pay_input_values_f iv1

Line 279: FROM pay_element_links_f links, per_all_assignments_f assign

275: --
276:
277: CURSOR link_csr(p_element_type_id IN NUMBER) IS
278: SELECT links.element_link_id
279: FROM pay_element_links_f links, per_all_assignments_f assign
280: WHERE links.element_type_id = p_element_type_id
281: AND links.business_group_id=p_business_group_id
282: AND assign.assignment_id=p_assignment_id
283: AND (( links.payroll_id is not null

Line 399: FROM pay_element_links_f links, per_all_assignments_f assign

395: --
396:
397: CURSOR link_csr(p_element_type_id IN NUMBER) IS
398: SELECT links.element_link_id
399: FROM pay_element_links_f links, per_all_assignments_f assign
400: WHERE links.element_type_id = p_element_type_id
401: AND links.business_group_id=p_business_group_id
402: AND assign.assignment_id=p_assignment_id
403: AND (( links.payroll_id is not null

Line 730: l_assg_id per_all_assignments_f.assignment_id%type;

726: l_flag number;
727: l_start_date date;
728: l_end_date date;
729: l_holidays varchar2(20);
730: l_assg_id per_all_assignments_f.assignment_id%type;
731: l_year varchar2(10);
732: l_name per_all_people_f.full_name%type;
733: l_return NUMBER;
734: l_param VARCHAR2(100);

Line 759: FROM per_all_assignments_f asg1

755:
756:
757: CURSOR check_run_id (p_assg_id number, p_run_id VARCHAR2) IS
758: SELECT 1
759: FROM per_all_assignments_f asg1
760: ,pay_element_types_f et
761: ,pay_input_values_f iv1
762: ,pay_element_entries_f ee
763: ,pay_element_entry_values_f eev1

Line 779: per_all_assignments_f asg1,

775:
776: CURSOR chk_multiple_assg(p_assig_no varchar2, p_cpr_no varchar2) IS
777: SELECT asg2.ASSIGNMENT_ID
778: FROM per_all_people_f per ,
779: per_all_assignments_f asg1,
780: per_all_assignments_f asg2
781: WHERE asg1.assignment_number = p_assig_no
782: AND per.NATIONAL_IDENTIFIER = p_cpr_no
783: AND asg1.person_id = per.person_id

Line 780: per_all_assignments_f asg2

776: CURSOR chk_multiple_assg(p_assig_no varchar2, p_cpr_no varchar2) IS
777: SELECT asg2.ASSIGNMENT_ID
778: FROM per_all_people_f per ,
779: per_all_assignments_f asg1,
780: per_all_assignments_f asg2
781: WHERE asg1.assignment_number = p_assig_no
782: AND per.NATIONAL_IDENTIFIER = p_cpr_no
783: AND asg1.person_id = per.person_id
784: AND per.person_id = asg2.person_id

Line 800: l_assignment_id per_all_assignments_f.assignment_id%type;

796: l_action_info_id NUMBER;
797: l_ovn NUMBER;
798: l_ele_link_id pay_element_links_f.element_link_id%type;
799: l_payroll_exists NUMBER;
800: l_assignment_id per_all_assignments_f.assignment_id%type;
801:
802: wrong_entit_year EXCEPTION;
803: person_not_found EXCEPTION;
804: assg_already_processed EXCEPTION;