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

Line 44: g_assignment_id per_all_assignments_f.assignment_id%TYPE;

40: g_si_days NUMBER;
41: /* Global Variables for Override SI Days ZVW */
42: g_si_days_zvw NUMBER;
43: /* Global Variables for Tax Proration Days */
44: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
45: g_tax_proration_days NUMBER;
46: g_tax_proration_flag VARCHAR2(1);
47:
48: cursor c_wp_dets(p_assignment_id NUMBER ) is

Line 396: from per_all_assignments_f paa,

392: OPEN c_wp_dets(P_Assignment_Id);
393: FETCH c_wp_dets INTO l_assgn_attr;
394: CLOSE c_wp_dets;
395: select person_id into l_person_id
396: from per_all_assignments_f paa,
397: fnd_sessions ses
398: where paa.assignment_id =p_assignment_id
399: and ses.session_id = userenv('sessionid')
400: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;

Line 923: ( p_assignment_id IN per_all_assignments_f.assignment_id%type ,

919: -- To get the average Pseudo SI Part time Percentage
920: -- Assignment Id,Period Start Date,Period End Date
921: -----------------------------------------------------------------------------------------------
922: FUNCTION get_avg_part_time_percentage
923: ( p_assignment_id IN per_all_assignments_f.assignment_id%type ,
924: p_period_start_date IN DATE ,
925: p_period_end_date IN DATE
926: )
927: RETURN NUMBER IS

Line 930: csr_get_part_time_per( p_assignment_id per_all_assignments_f.assignment_id%type,

926: )
927: RETURN NUMBER IS
928: -- Cursor to retrieve part time percentages and effective start and end dates for an assignment.
929: CURSOR
930: csr_get_part_time_per( p_assignment_id per_all_assignments_f.assignment_id%type,
931: p_period_start_date DATE ,
932: p_period_end_date DATE
933: ) IS
934: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(hs.segment29) segment29 ,

Line 939: per_all_assignments_f pas

935: pas.effective_start_date effective_start_date,
936: pas.effective_end_date effective_end_date
937: FROM
938: hr_soft_coding_keyflex hs ,
939: per_all_assignments_f pas
940: WHERE
941: pas.assignment_id = p_assignment_id AND
942: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND
943: pas.effective_start_date <= p_period_end_date AND

Line 945: l_ef_start_date per_all_assignments_f.effective_start_date%type;

941: pas.assignment_id = p_assignment_id AND
942: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND
943: pas.effective_start_date <= p_period_end_date AND
944: pas.effective_end_date >= p_period_start_date ;
945: l_ef_start_date per_all_assignments_f.effective_start_date%type;
946: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
947: l_period_start_date DATE;
948: l_period_end_date DATE;
949: l_asg_start_date DATE;

Line 946: l_ef_end_date per_all_assignments_f.effective_end_date%type ;

942: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND
943: pas.effective_start_date <= p_period_end_date AND
944: pas.effective_end_date >= p_period_start_date ;
945: l_ef_start_date per_all_assignments_f.effective_start_date%type;
946: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
947: l_period_start_date DATE;
948: l_period_end_date DATE;
949: l_asg_start_date DATE;
950: l_asg_end_date DATE;

Line 1063: ( p_assignment_id IN per_all_assignments_f.assignment_id%type ,

1059: End IsLeapYear ;
1060:
1061:
1062: FUNCTION get_asg_ind_work_hours
1063: ( p_assignment_id IN per_all_assignments_f.assignment_id%type ,
1064: p_period_start_date IN DATE ,
1065: p_period_end_date IN DATE
1066: )
1067: RETURN NUMBER IS

Line 1070: csr_get_ind_work_hrs( p_assignment_id per_all_assignments_f.assignment_id%type,

1066: )
1067: RETURN NUMBER IS
1068: -- Cursor to retrieve part time percentages and effective start and end dates for an assignment.
1069: CURSOR
1070: csr_get_ind_work_hrs( p_assignment_id per_all_assignments_f.assignment_id%type,
1071: p_period_start_date DATE ,
1072: p_period_end_date DATE
1073: ) IS
1074: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(scl.segment28) segment28 ,

Line 1080: per_all_assignments_f paa

1076: paa.effective_start_date effective_start_date,
1077: paa.effective_end_date effective_end_date
1078: FROM
1079: hr_soft_coding_keyflex scl ,
1080: per_all_assignments_f paa
1081: WHERE
1082: paa.assignment_id = p_assignment_id AND
1083: scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id AND
1084: paa.effective_start_date <= p_period_end_date AND

Line 1090: l_ef_start_date per_all_assignments_f.effective_start_date%type;

1086:
1087: TYPE days_month IS TABLE OF NUMBER;
1088: days_in days_month;
1089:
1090: l_ef_start_date per_all_assignments_f.effective_start_date%type;
1091: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
1092: l_period_start_date DATE;
1093: l_period_end_date DATE;
1094: l_asg_start_date DATE;

Line 1091: l_ef_end_date per_all_assignments_f.effective_end_date%type ;

1087: TYPE days_month IS TABLE OF NUMBER;
1088: days_in days_month;
1089:
1090: l_ef_start_date per_all_assignments_f.effective_start_date%type;
1091: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
1092: l_period_start_date DATE;
1093: l_period_end_date DATE;
1094: l_asg_start_date DATE;
1095: l_asg_end_date DATE;