APPS.PAY_NL_DIM_PKG dependencies on PER_TIME_PERIODS

Line 28: from per_time_periods ptp, pay_payroll_actions ppa

24: l_period_start_date date;
25: BEGIN
26: select ptp.start_date
27: into l_period_start_date
28: from per_time_periods ptp, pay_payroll_actions ppa
29: where ppa.payroll_action_id = p_user_payroll_action_id
30: and ppa.payroll_id = ptp.payroll_id
31: and p_user_effective_date between ptp.start_date and ptp.end_date;
32: -- see if balance was written in this period. If not it is expired

Line 53: FROM per_time_periods TP

49: ) IS
50: BEGIN
51: SELECT TP.end_date
52: INTO p_expiry_information
53: FROM per_time_periods TP
54: ,pay_payroll_actions PACT
55: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
56: AND PACT.payroll_id = TP.payroll_id
57: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line 88: from per_time_periods ptp, pay_payroll_actions ppa

84: l_period_start_date date;
85: BEGIN
86: select ptp.start_date
87: into l_period_start_date
88: from per_time_periods ptp, pay_payroll_actions ppa
89: where ppa.payroll_action_id = p_user_payroll_action_id
90: and ppa.payroll_id = ptp.payroll_id
91: and p_user_effective_date between ptp.start_date and ptp.end_date;
92: -- see if balance was written in this period. If not it is expired

Line 113: FROM per_time_periods TP

109: ) IS
110: BEGIN
111: SELECT TP.end_date
112: INTO p_expiry_information
113: FROM per_time_periods TP
114: ,pay_payroll_actions PACT
115: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
116: AND PACT.payroll_id = TP.payroll_id
117: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line 362: from per_time_periods ptp, pay_payroll_actions ppa

358: l_period_start_date date;
359: BEGIN
360: select ptp.start_date
361: into l_period_start_date
362: from per_time_periods ptp, pay_payroll_actions ppa
363: where ppa.payroll_action_id = p_user_payroll_action_id
364: and ppa.payroll_id = ptp.payroll_id
365: and p_user_effective_date between ptp.start_date and ptp.end_date;
366: -- see if balance was written in this period. If not it is expired

Line 387: from per_time_periods ptp, pay_payroll_actions ppa

383: ) IS
384: BEGIN
385: select ptp.END_DATE
386: into p_expiry_information
387: from per_time_periods ptp, pay_payroll_actions ppa
388: where ppa.payroll_action_id = p_user_payroll_action_id
389: and ppa.payroll_id = ptp.payroll_id
390: and p_owner_effective_date between ptp.start_date and ptp.end_date;
391: END;

Line 417: from per_time_periods ptp, pay_payroll_actions ppa

413: l_period_start_date date;
414: BEGIN
415: select ptp.start_date
416: into l_period_start_date
417: from per_time_periods ptp, pay_payroll_actions ppa
418: where ppa.payroll_action_id = p_user_payroll_action_id
419: and ppa.payroll_id = ptp.payroll_id
420: and p_user_effective_date between ptp.start_date and ptp.end_date;
421: -- see if balance was written in this period. If not it is expired

Line 442: FROM per_time_periods TP

438: ) IS
439: BEGIN
440: SELECT TP.end_date
441: INTO p_expiry_information
442: FROM per_time_periods TP
443: ,pay_payroll_actions PACT
444: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
445: AND PACT.payroll_id = TP.payroll_id
446: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line 823: FROM per_time_periods TP

819: ) IS
820: BEGIN
821: SELECT TP.end_date
822: INTO p_expiry_information
823: FROM per_time_periods TP
824: ,pay_payroll_actions PACT
825: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
826: AND PACT.payroll_id = TP.payroll_id
827: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line 852: FROM per_time_periods ptp, pay_payroll_actions ppa

848: BEGIN
849: --
850: SELECT ptp.start_date
851: INTO l_period_start_date
852: FROM per_time_periods ptp, pay_payroll_actions ppa
853: WHERE ppa.payroll_action_id = p_user_payroll_action_id
854: AND ppa.payroll_id = ptp.payroll_id
855: AND p_user_effective_date BETWEEN ptp.start_date AND ptp.end_date;
856: -- see if balance was written in this period. If not it is expired

Line 878: FROM per_time_periods TP

874: ) IS
875: BEGIN
876: SELECT TP.end_date
877: INTO p_expiry_information
878: FROM per_time_periods TP
879: ,pay_payroll_actions PACT
880: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
881: AND PACT.payroll_id = TP.payroll_id
882: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line 943: FROM per_time_periods TP

939: l_no_days NUMBER;
940: BEGIN
941: SELECT MAX(TP.period_num)
942: INTO l_max_period
943: FROM per_time_periods TP
944: ,pay_payroll_actions PACT
945: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
946: AND PACT.payroll_id = TP.payroll_id
947: AND TP.end_date BETWEEN TRUNC(p_owner_effective_date,'Y')

Line 953: FROM per_time_periods TP

949:
950: IF l_max_period = 13 then
951: SELECT TP.end_date
952: INTO p_expiry_information
953: FROM per_time_periods TP
954: ,pay_payroll_actions PACT
955: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
956: AND PACT.payroll_id = TP.payroll_id
957: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;

Line 1037: FROM per_time_periods TP

1033: l_no_days NUMBER;
1034: BEGIN
1035: SELECT MAX(TP.period_num)
1036: INTO l_max_period
1037: FROM per_time_periods TP
1038: ,pay_payroll_actions PACT
1039: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
1040: AND PACT.payroll_id = TP.payroll_id
1041: AND TP.end_date BETWEEN TRUNC(p_owner_effective_date,'Y')

Line 1047: FROM per_time_periods TP

1043:
1044: IF l_max_period = 13 then
1045: SELECT TP.end_date
1046: INTO p_expiry_information
1047: FROM per_time_periods TP
1048: ,pay_payroll_actions PACT
1049: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
1050: AND PACT.payroll_id = TP.payroll_id
1051: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;