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 42: g_assignment_id per_all_assignments_f.assignment_id%TYPE;

38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;
39: g_si_days_formula_name ff_formulas_f.formula_name%TYPE;
40: g_si_days NUMBER;
41: /* Global Variables for Tax Proration Days */
42: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
43: g_tax_proration_days NUMBER;
44: g_tax_proration_flag VARCHAR2(1);
45:
46: cursor c_wp_dets(p_assignment_id NUMBER ) is

Line 379: from per_all_assignments_f paa,

375: OPEN c_wp_dets(P_Assignment_Id);
376: FETCH c_wp_dets INTO l_assgn_attr;
377: CLOSE c_wp_dets;
378: select person_id into l_person_id
379: from per_all_assignments_f paa,
380: fnd_sessions ses
381: where paa.assignment_id =p_assignment_id
382: and ses.session_id = userenv('sessionid')
383: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;

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

902: -- To get the average Pseudo SI Part time Percentage
903: -- Assignment Id,Period Start Date,Period End Date
904: -----------------------------------------------------------------------------------------------
905: FUNCTION get_avg_part_time_percentage
906: ( p_assignment_id IN per_all_assignments_f.assignment_id%type ,
907: p_period_start_date IN DATE ,
908: p_period_end_date IN DATE
909: )
910: RETURN NUMBER IS

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

909: )
910: RETURN NUMBER IS
911: -- Cursor to retrieve part time percentages and effective start and end dates for an assignment.
912: CURSOR
913: csr_get_part_time_per( p_assignment_id per_all_assignments_f.assignment_id%type,
914: p_period_start_date DATE ,
915: p_period_end_date DATE
916: ) IS
917: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(hs.segment29) segment29 ,

Line 922: per_all_assignments_f pas

918: pas.effective_start_date effective_start_date,
919: pas.effective_end_date effective_end_date
920: FROM
921: hr_soft_coding_keyflex hs ,
922: per_all_assignments_f pas
923: WHERE
924: pas.assignment_id = p_assignment_id AND
925: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND
926: pas.effective_start_date <= p_period_end_date AND

Line 928: l_ef_start_date per_all_assignments_f.effective_start_date%type;

924: pas.assignment_id = p_assignment_id AND
925: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND
926: pas.effective_start_date <= p_period_end_date AND
927: pas.effective_end_date >= p_period_start_date ;
928: l_ef_start_date per_all_assignments_f.effective_start_date%type;
929: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
930: l_period_start_date DATE;
931: l_period_end_date DATE;
932: l_asg_start_date DATE;

Line 929: l_ef_end_date per_all_assignments_f.effective_end_date%type ;

925: hs.soft_coding_keyflex_id = pas.soft_coding_keyflex_id AND
926: pas.effective_start_date <= p_period_end_date AND
927: pas.effective_end_date >= p_period_start_date ;
928: l_ef_start_date per_all_assignments_f.effective_start_date%type;
929: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
930: l_period_start_date DATE;
931: l_period_end_date DATE;
932: l_asg_start_date DATE;
933: l_asg_end_date DATE;

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

1042: End IsLeapYear ;
1043:
1044:
1045: FUNCTION get_asg_ind_work_hours
1046: ( p_assignment_id IN per_all_assignments_f.assignment_id%type ,
1047: p_period_start_date IN DATE ,
1048: p_period_end_date IN DATE
1049: )
1050: RETURN NUMBER IS

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

1049: )
1050: RETURN NUMBER IS
1051: -- Cursor to retrieve part time percentages and effective start and end dates for an assignment.
1052: CURSOR
1053: csr_get_ind_work_hrs( p_assignment_id per_all_assignments_f.assignment_id%type,
1054: p_period_start_date DATE ,
1055: p_period_end_date DATE
1056: ) IS
1057: SELECT FND_NUMBER.CANONICAL_TO_NUMBER(scl.segment28) segment28 ,

Line 1063: per_all_assignments_f paa

1059: paa.effective_start_date effective_start_date,
1060: paa.effective_end_date effective_end_date
1061: FROM
1062: hr_soft_coding_keyflex scl ,
1063: per_all_assignments_f paa
1064: WHERE
1065: paa.assignment_id = p_assignment_id AND
1066: scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id AND
1067: paa.effective_start_date <= p_period_end_date AND

Line 1073: l_ef_start_date per_all_assignments_f.effective_start_date%type;

1069:
1070: TYPE days_month IS TABLE OF NUMBER;
1071: days_in days_month;
1072:
1073: l_ef_start_date per_all_assignments_f.effective_start_date%type;
1074: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
1075: l_period_start_date DATE;
1076: l_period_end_date DATE;
1077: l_asg_start_date DATE;

Line 1074: l_ef_end_date per_all_assignments_f.effective_end_date%type ;

1070: TYPE days_month IS TABLE OF NUMBER;
1071: days_in days_month;
1072:
1073: l_ef_start_date per_all_assignments_f.effective_start_date%type;
1074: l_ef_end_date per_all_assignments_f.effective_end_date%type ;
1075: l_period_start_date DATE;
1076: l_period_end_date DATE;
1077: l_asg_start_date DATE;
1078: l_asg_end_date DATE;