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_DK_TC_DP_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 56: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

52: L_ASSIGNMENT_USER_KEY VARCHAR2(240);
53: L_ELEMENT_LINK_USER_KEY VARCHAR2(240);
54: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
55: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
56: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
57: l_datetrack_update_mode VARCHAR2(80);
58:
59: -- Variables to Read from File
60: l_cpr VARCHAR2(80);

Line 132: ,p_date per_all_assignments_f.effective_start_date%TYPE)

128:
129: CURSOR csr_get_prim_assg
130: ( p_business_group_id per_business_groups.business_group_id%TYPE
131: ,p_cpr per_all_people_f.national_identifier%TYPE
132: ,p_date per_all_assignments_f.effective_start_date%TYPE)
133: IS
134: SELECT PAA.ASSIGNMENT_ID
135: FROM per_all_assignments_f PAA
136: , per_all_people_f PAP

Line 135: FROM per_all_assignments_f PAA

131: ,p_cpr per_all_people_f.national_identifier%TYPE
132: ,p_date per_all_assignments_f.effective_start_date%TYPE)
133: IS
134: SELECT PAA.ASSIGNMENT_ID
135: FROM per_all_assignments_f PAA
136: , per_all_people_f PAP
137: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
138: AND PAP.per_information_category ='DK'
139: AND PAP.NATIONAL_IDENTIFIER = p_cpr

Line 145: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_date per_all_assignments_f.effective_start_date%TYPE)

141: AND PAA.PRIMARY_FLAG = 'Y'
142: AND p_date between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
143: AND p_date between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE ;
144:
145: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_date per_all_assignments_f.effective_start_date%TYPE)
146: IS
147: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
148: from pay_element_entries_f pee
149: , pay_element_types_f pet

Line 151: , per_all_assignments_f paa

147: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
148: from pay_element_entries_f pee
149: , pay_element_types_f pet
150: , pay_element_links_f pel
151: , per_all_assignments_f paa
152: where pet.ELEMENT_NAME = 'Tax Card'
153: and pet.legislation_code = 'DK'
154: and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
155: and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID

Line 1124: ,p_date IN per_all_assignments_f.effective_start_date%TYPE

1120: FUNCTION get_element_link_id
1121: (
1122: p_assignment_id IN NUMBER
1123: ,p_business_group_id IN NUMBER
1124: ,p_date IN per_all_assignments_f.effective_start_date%TYPE
1125: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE
1126: ) RETURN NUMBER
1127: IS
1128: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;

Line 1131: FROM per_all_assignments_f

1127: IS
1128: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
1129: CURSOR csr_get_payroll_id IS
1130: SELECT payroll_id
1131: FROM per_all_assignments_f
1132: WHERE business_group_id = p_business_group_id
1133: AND assignment_id = p_assignment_id
1134: AND p_date
1135: BETWEEN effective_start_date AND effective_end_date ;