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_CA_WF_PKG dependencies on HR_LOOKUPS

Line 857: from hr_lookups

853: between r.effective_start_date and r.effective_end_date;
854:
855: cursor cur_sdr_reporting_dimension is
856: select meaning
857: from hr_lookups
858: where lookup_code = p_sdr_reporting_dimension
859: and lookup_type = 'PAY_CA_REPORT_DIMENSION'
860: and application_id = 800;
861:

Line 942: from hr_lookups

938: where org_payment_method_id = to_number(p_cheque_payment_method);
939:
940: cursor cur_cheque_sort_seq is
941: select meaning
942: from hr_lookups
943: where lookup_code = p_cheque_sort_sequence
944: and lookup_type = 'CHEQUE_PROCEDURE'
945: and enabled_flag = 'Y';
946:

Line 949: from hr_lookups

945: and enabled_flag = 'Y';
946:
947: cursor cur_cheque_style is
948: select meaning
949: from hr_lookups
950: where lookup_code = p_cheque_style
951: and lookup_type = 'CA_CHEQUE_DEPADV'
952: and enabled_flag = 'Y';
953:

Line 956: from hr_lookups

952: and enabled_flag = 'Y';
953:
954: cursor cur_deposit_advice_data_type is
955: select meaning
956: from hr_lookups
957: where lookup_code = p_da_data_type
958: and lookup_type = 'DAR_REPORT'
959: and enabled_flag = 'Y';
960:

Line 984: from hr_lookups

980: between effective_start_date and effective_end_date;
981:
982: cursor cur_costing_summary_accruals is
983: select meaning
984: from hr_lookups
985: where lookup_code = p_cost_summary_accruals
986: and lookup_type = 'PAY_PAYRPCBR';
987:
988: cursor cur_costing_summary_file_out is

Line 1023: from hr_lookups

1019: where assignment_set_id = to_number(p_cost_detail_asg_set);
1020:
1021: cursor cur_costing_detail_accruals is
1022: select meaning
1023: from hr_lookups
1024: where lookup_code = p_cost_detail_accruals
1025: and lookup_type = 'PAY_PAYRPCBR';
1026:
1027:

Line 1541: from hr_lookups

1537:
1538: begin
1539: select meaning
1540: into lv_reg_sort_one
1541: from hr_lookups
1542: where lookup_code = p_reg_sort_one
1543: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1544:
1545: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );

Line 1555: from hr_lookups

1551:
1552: begin
1553: select meaning
1554: into lv_reg_sort_two
1555: from hr_lookups
1556: where lookup_code = p_reg_sort_two
1557: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1558:
1559: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );

Line 1569: from hr_lookups

1565:
1566: begin
1567: select meaning
1568: into lv_reg_sort_three
1569: from hr_lookups
1570: where lookup_code = p_reg_sort_three
1571: and lookup_type = 'PAY_CA_YE_SORT_CODE';
1572:
1573: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );

Line 2986: from hr_lookups

2982: between r.effective_start_date and r.effective_end_date;
2983:
2984: cursor cur_sdr_reporting_dimension is
2985: select meaning
2986: from hr_lookups
2987: where lookup_code = p_sdr_reporting_dimension
2988: and lookup_type = 'PAY_CA_REPORT_DIMENSION'
2989: and application_id = 800;
2990:

Line 3071: from hr_lookups

3067: where org_payment_method_id = to_number(p_cheque_payment_method);
3068:
3069: cursor cur_cheque_sort_seq is
3070: select meaning
3071: from hr_lookups
3072: where lookup_code = p_cheque_sort_sequence
3073: and lookup_type = 'CHEQUE_PROCEDURE'
3074: and enabled_flag = 'Y';
3075:

Line 3078: from hr_lookups

3074: and enabled_flag = 'Y';
3075:
3076: cursor cur_cheque_style is
3077: select meaning
3078: from hr_lookups
3079: where lookup_code = p_cheque_style
3080: and lookup_type = 'CA_CHEQUE_DEPADV'
3081: and enabled_flag = 'Y';
3082:

Line 3085: from hr_lookups

3081: and enabled_flag = 'Y';
3082:
3083: cursor cur_deposit_advice_data_type is
3084: select meaning
3085: from hr_lookups
3086: where lookup_code = p_da_data_type
3087: and lookup_type = 'DAR_REPORT'
3088: and enabled_flag = 'Y';
3089:

Line 3113: from hr_lookups

3109: between effective_start_date and effective_end_date;
3110:
3111: cursor cur_costing_summary_accruals is
3112: select meaning
3113: from hr_lookups
3114: where lookup_code = p_cost_summary_accruals
3115: and lookup_type = 'PAY_PAYRPCBR';
3116:
3117: cursor cur_costing_summary_file_out is

Line 3152: from hr_lookups

3148: where assignment_set_id = to_number(p_cost_detail_asg_set);
3149:
3150: cursor cur_costing_detail_accruals is
3151: select meaning
3152: from hr_lookups
3153: where lookup_code = p_cost_detail_accruals
3154: and lookup_type = 'PAY_PAYRPCBR';
3155:
3156:

Line 3677: from hr_lookups

3673:
3674: begin
3675: select meaning
3676: into lv_reg_sort_one
3677: from hr_lookups
3678: where lookup_code = p_reg_sort_one
3679: and lookup_type = 'PAY_CA_YE_SORT_CODE';
3680:
3681: hr_utility.trace('lv_reg_sort_one = ' || lv_reg_sort_one );

Line 3691: from hr_lookups

3687:
3688: begin
3689: select meaning
3690: into lv_reg_sort_two
3691: from hr_lookups
3692: where lookup_code = p_reg_sort_two
3693: and lookup_type = 'PAY_CA_YE_SORT_CODE';
3694:
3695: hr_utility.trace('lv_reg_sort_two = ' || lv_reg_sort_two );

Line 3705: from hr_lookups

3701:
3702: begin
3703: select meaning
3704: into lv_reg_sort_three
3705: from hr_lookups
3706: where lookup_code = p_reg_sort_three
3707: and lookup_type = 'PAY_CA_YE_SORT_CODE';
3708:
3709: hr_utility.trace('lv_reg_sort_three = ' || lv_reg_sort_three );